Shulou(Shulou.com)05/31 Report--

This article introduces you how to import ora39242 in impdp, the content is very detailed, interested friends can refer to, hope to be helpful to you.

When using impdp for data recovery (the same version of the database), importing data failed, prompting ORA39242: table attribute reason, resulting in import failure

At first, I thought there was a problem with the backup. I looked at the original backup and imported it into the database of another server and found that it could be imported normally.

Checked the user's permissions, table structure, and directory permissions and found no problems.

Finally, query some data, mention that there is a problem with the table index, and randomly check the index status of the target database.

Select index_name,table_name,status from dba_indexes where status! = 'VALID' and owner='xxx'

It is found that all of these tables have invalid indexes under this user:

Then execute: ALTER INDEX index_name REBUILD

On how to import ora39242 in impdp to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.