Re: Rebuilding SYS tables?

Hello Sybrand,
Thanks for responding.

The reason I believe I they are "corrupt" or I mean have "corrupt data in them" is when I do a full exp I get the following error message:

. exporting posttables actions

EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

I have seen a bug #1249652 mentioned but I don't believe that is the case here. Any input is greatly appreciated.

Thanks, DJ

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0201250115.2fb2c455_at_posting.google.com...
> "djones" <nospam_at_nospam.com> wrote in message
 news:<3c50361c_1_at_corp-news.newsgroups.com>...
> > Hello,
> >
> > It appears my SYS tables are corrupted. I suspect this happened during
 an
> > import while syncing two databases (ignore existent of object error =
 Y).
> > Without being able to use import again, is there a way I can rebuild
> > (analyze?) those tables?
> >
> > Thanks,
> > DJ
>
> No, the tables are 'built' as a result of DDL statements. Other than
> destroying and recreating the database and re-importing, the only
> solution is to restore a backup. Import definitely doesn't 'corrupt'
> the dictionary.
> Also please define 'corrupt'
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Fri Jan 25 2002 - 23:01:40 CET