cancel
Showing results for 
Search instead for 
Did you mean: 

Export error

Yash99
Occasional Advisor

Export error

Hi
I am getting internal inconsistency error while exporting partitioned tables in oracle 9.2.0.6.
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully
i AM USING FOLLOWING PARAMETER FILE TO EXPORT THE partitioned tables.
more CIS_opt.par
userid=xyz/xyz
file=/float/export/tables_1.dmp,/float/export/tables_2.dmp,/float/export/tables_ 3.dmp,/float/export/tables_4.dmp
filesize=10000M
consistent=Y
log=cis_opt.log
tables=CIS.UCS_DETAILS,CIS.MIC_CONTACT

Please let me know if anyone has faced such issues.

5 REPLIES
Hein van den Heuvel
Honored Contributor

Re: Export error

May we assume this is on an HP-UX platform? Version?

Has this ever worked?
What changed? (more data? patches? upgrades?)
How long before the error, versus how long it was expected to take?
Does it even start?

Any further detail errors in a log, or corresponding .TRC file?

I'm sure you read the error description right?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/expus.htm

"EXP-00006: internal inconsistency error
Cause: Export"s data structure was corrupted.
Action: Record the accompanying messages and report this as an Export internal error to customer support."

With that they mean ORACLE customer support, as this is 99.99% sure to be an Oracle issue, not something HPUX related.

Do those tables appear to be in good shape?
Can you 'describe' them? Count them?

Good Luck!
Hein van den Heuvel

Yogeeraj_1
Honored Contributor

Re: Export error

hi,

Allow me to ask a few more questions on top of those of Hein above:

- Are you able to export other table (non-partitioned) data?
- What is the approximate size of the table (MB/GB)?
- does the following queries run successfully?
o select count(*) from CIS.UCS_DETAILS;
o select count(*) from CIS.MIC_CONTACT;

can you also post the logfile cis_opt.log?


revert!
kind regards
yogeeraj


No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yash99
Occasional Advisor

Re: Export error

Thanks for the Update.
I have taking this issue with Oracle Metalink.

Regards
Yash
Yash99
Occasional Advisor

Re: Export error

Issue is resolved Hence Closing the Thread.
Patrick Wallek
Honored Contributor

Re: Export error

Could you post the resolution to the problem, please? If someone finds this thread in the future, the solution could help them.