Tag: import
Possible Causes to ORA-00980 Synonym Transaltion no longer valid
ORA-00980: synonym translation is no longer valid
This error usually means that the synonym used is based on a table, view, or synonym that no longer exists. in order to fix it you will need to replace the synonym with the name of the object it references or re-create the synonym so that it refers to [...]
Posted: June 23rd, 2009 under Oracle.
Tags: export, import, ORA-00980, Oracle
Comments: none
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