ORA-01403 while exporting auditing options

[Unna]

Dear all,

Recently I have installed a patchset on database server; after the installation I ran catalog.sql, catproc.sql, and catexp.sql. The database seems to run fine so far, except the full export. Every time when I run a full export, I got these errors:

..
. exporting referential integrity constraints
. exporting posttables actions
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting triggers
. exporting default and system auditing options
EXP-00016: ORACLE error encountered while reading default auditing options
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
Export terminated successfully with warnings.

I searched the metalink and found a document that suggested running all the necessary upgrade scripts. I am not sure what upgrade scripts I need to run other than catalog.sql, catproc.sql, and catexp.sql. Can anyone shed any light on these errors? Any advice?


Thanks for your help,
Unna

[akhadar]

one of the option is rerun catexp.sql

[Unna]

I tried that already, that didn't work. I still get the same export errors. Any suggestion? Any help will be appreciated.


Thanks!

[gandolf989]

What version of Oracle and what OS are you using?
Have you looked at Metalink?

[nagarjuna]

Are you running the export command from the same server itself or from some other server that has different Oracle server version?

[Unna]

We are still running 7 on Sun Solaris and we will be soon migrating to 9i.

I searched Metalink and found a document that suggested running all the necessary upgrade scripts and catexp.sql. I am not sure what are the upgrade scripts and where I can find them. I re-ran catexp.sql, which didn't make any difference. I also searched other websites like asktome.com, found nothing about them. I am not sure these errors only appear in 7 and they are bugs or something?


I am running the export command from the same server.


Thanks,
Unna