Home » RDBMS Server » Server Administration » IMPDP gives failed messages in oracle 19c (oracle 19c)
IMPDP gives failed messages in oracle 19c [message #677056] Tue, 13 August 2019 06:30 Go to next message
sreekanth3y
Messages: 2
Registered: August 2019
Junior Member
Migrated DB from 12c and 19c with IMPDP utility , while importing I have seen some error, below is the trace for the same

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

VM247_RCDB_121GA.PK_TXI : sqlerrm = ORA-20000: Unable to set values for index PK _TXI: does not exist or insufficient privileges

VM247_RCDB_121GA.PK_ARRE : sqlerrm = ORA-20000: Unable to set values for index P K_ARRE: does not exist or insufficient privileges

VM247_RCDB_121GA.PK_ARA : sqlerrm = ORA-20000: Unable to set values for index PK _ARA: does not exist or insufficient privileges

VM247_RCDB_121GA.SYS_C0034921 : sqlerrm = ORA-20000: Unable to set values for in dex SYS_C0034921: does not exist or insufficient privileges

VM247_RCDB_121GA.PK_TXA : sqlerrm = ORA-20000: Unable to set values for index PK _TXA: does not exist or insufficient privileges

Importing statistics failed for 20 object(s);

Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 22 error(s) at Wed Aug 7 08:2 8:32 2019 elapsed 0 00:05:25


and utilites are: (expdp from 12c and impdp from 19c)

expdp system/admin@orcl schemas=VM247_RCDB_121GA directory=DATA_PUMP_DIR dumpfile=VM247_RCDB_121V10.dmp logfile=VM247_RCDB_121V10.log

impdp system/admin@orcl19c schemas=VM247_RCDB_121GA directory=DATA_PUMP_DIR dumpfile=VM247_RCDB_121V10.DMP logfile=VM247_RCDB_121V10_imp.log
Re: IMPDP gives failed messages in oracle 19c [message #677057 is a reply to message #677056] Tue, 13 August 2019 07:27 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

I wouldn't worry about those "errors". Assuming that the indexes did get created (have you checked that?) they are to do with setting the statistics on the indexes, and after an import the stat's are usually completely wrong for the new environment. So just gather them again, which you need to do anyway.
Re: IMPDP gives failed messages in oracle 19c [message #677060 is a reply to message #677057] Wed, 14 August 2019 01:41 Go to previous messageGo to next message
sreekanth3y
Messages: 2
Registered: August 2019
Junior Member
Yes, indexes got created. The only difference i can see for these PK indexes are their details contains CONSTRAINT_INDEX as NO value and other PK Indexes contains as YES. this CONSTRAINT_INDEX is available only in 19c.

do we need to do any action for these indexes?
Re: IMPDP gives failed messages in oracle 19c [message #677062 is a reply to message #677060] Wed, 14 August 2019 05:19 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I can't see why there is any action needed (other than that I already suggested). That CONSTRAINT_INDEX column isn't documented but all it does (I think) is tell you whether the index will be dropped if you drop the constraint. Perhaps the indexes were created implicitly and then renamed, something like that might cause this sort of confusion.

You could raise a TAR to check with Support.
Previous Topic: How To View Contents of the Alert Log using a Query
Next Topic: ASM interview question
Goto Forum:
  


Current Time: Thu Mar 28 07:04:29 CDT 2024