My call to Oracle's exp is failing with:
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully
The command I execute is
C:\oracle\product\11.1.0\db_1\BIN\exp user/pass@instance file=dump.dmp log=log.log compress=y owner=user
The table that is failing is contains
- 1 not null number(38) columns (primary key)
- 18 varchar2(100) columns
The primary key is also a foreign key to another table.
All search results say that I should contact Oracle, but isn't there someother fix for this problem? Maybe a rebuild of a table?
Best Answer
If you have Oracle Support, then tell them. It can be an internal problem with export itself and they will request additional information, tell you what to try and so on, until you resolve the problem. You will probably also get a patch/fix if there is.
I would suggest doing the export with datapump instead as export is long time deprecated. You need to define a directory where oracle should drop exported data into, then start datapump. It's easy, faster and more reliable and flexible than import/export.
Example:
Then run:
Addition: Looks like you have problems with consistency of the DB. Run logical and physical validation with RMAN to catch any other problems:
Code is generic, this snippet borrowed from http://oraclespin.wordpress.com/2008/06/11/how-to-check-physical-and-logical-data-corruption-using-rman/