Wednesday, January 19, 2011

11g DataPump Import Errors: ORA-20005, ORA-39083, DRG-10507,ORA-02158, ORA-39112

This is a space holder for Data Pump Import errors I encountered tonight.  The post will be expanded later with more information:
1 ORA-20005: object statistics are locked (stattype = ALL)
    Locked table statistics and subsequent create index
    IMP ORA-20005: object statistics are locked
    How to lock/unlock statistics on a table?
    DataPump Import Without Data Locks Table Statistics [ID 415081.1]

ORA-39083 And DRG-10507 Errors On Datapump Import [ID 987033.1]

IMPDP Raises ORA-39083, ORA-02158, ORA-39112 When Importing Compressed Indexes [ID 989232.1]

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home