Tag: data pump
Restart Data Pump after import errors
When using Data Pump, you may encounter the following error:
ORA-39171: Job is experiencing a resumable wait.
Together with
ORA-01653: Unable to extend table %s.%s by %s in tablespace %s
Or
ORA-01691 unable to extend lob segment string.string by string in tablespace string
Both errors basically say that the table space you are using can not allocate more space. This [...]
Posted: March 9th, 2009 under Oracle.
Tags: data pump, expdp, export, impdb, import, ORA-01653, ORA-01691, ORA-39171, Oracle
Comments: 2
Common reasons for IMP-00010 during import
If you try to import a file and you get the following error:
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
The cause according to Oracle error description is “Either the file was not generated by Export or it was corrupted”. The first obvious reason might be that the file is corrupted. However, [...]
Posted: March 3rd, 2009 under Uncategorized.
Tags: data pump, EXP, expdp, export, IMP, impdp, import, Oracle
Comments: 1