Home » RDBMS Server » Server Utilities » EXP-00008, ORA-01403 error on full export
EXP-00008, ORA-01403 error on full export [message #74229] Thu, 14 October 2004 13:15 Go to next message
RogersJ
Messages: 2
Registered: October 2004
Junior Member
This problem is occuring in an 8.1.7.4 database running on HPUX 11.0

I recently patched the Oracle software to meet security alert #68.

This is the error when running a full export with the following parameters
full=y compress=n direct=y consistent=y

. about to export XXXXX's tables via Direct Path ...
. . exporting table                 ALL_PRD_CACHED
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
. exporting referential integrity constraints

Tried rerunning catexp.sql - no difference
Also tried:
    DELETE FROM SYS.EXPACT$ WHERE     
    FUNC_PACKAGE='DBMS_AQ_IMPORT_INTERNAL';  - no difference

I do not get this error when I export only XXXXX's objects.

Thanks for any help.
Re: EXP-00008, ORA-01403 error on full export [message #74233 is a reply to message #74229] Fri, 15 October 2004 03:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
after patching/upgrade did you run catpatch.sql?
Re: EXP-00008, ORA-01403 error on full export [message #74242 is a reply to message #74233] Mon, 18 October 2004 13:14 Go to previous messageGo to next message
RogersJ
Messages: 2
Registered: October 2004
Junior Member
catpatch.sql is not part of the patch set.

It also doesnot reside in $ORACLE_HOME/rdbms/admin

Where would I find it ?
Re: EXP-00008, ORA-01403 error on full export [message #74539 is a reply to message #74229] Mon, 03 January 2005 21:37 Go to previous message
Raghavendra
Messages: 69
Registered: December 2000
Member
I got following error message while exporting data
EXP-00008: ORACLE error 1403 encountered
pls give the solution
Previous Topic: oracle server
Next Topic: URGENT:-Export problem
Goto Forum:
  


Current Time: Mon May 20 01:13:27 CDT 2024