topic Re: Export error in Operating System - HP-UX

Export error

Yash99 — Sat, 07 Jun 2008 02:13:16 GMT

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.

Re: Export error

Hein van den Heuvel — Sat, 07 Jun 2008 03:00:55 GMT

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

Re: Export error

Yogeeraj_1 — Sat, 07 Jun 2008 07:05:07 GMT

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

Re: Export error

Yash99 — Sun, 08 Jun 2008 13:38:51 GMT

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

Regards
Yash

Re: Export error

Yash99 — Sun, 08 Jun 2008 13:41:27 GMT

Issue is resolved Hence Closing the Thread.

Re: Export error

Patrick Wallek — Sun, 08 Jun 2008 17:38:57 GMT

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