Export error

[Yash99]

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.

[Hein van den Heuvel]

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]

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

[Yash99]

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

Regards
Yash

[Yash99]

Issue is resolved Hence Closing the Thread.

[Patrick Wallek]

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