Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Downgrade problem

Fahd.MirzaMar 4 2006 — edited Mar 6 2006

I have downgraded my database from 10gR2 to 9iR2.

When I export full database, the export completes successfully, but gives the following errors while exporting pre-schema objects,

EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: AT "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occured whe calling SYS.DBMS_AQ_EXP_QEUES.create_exp for object 53666

I am really really apprehensive, tentative and scared to temper with SYS schema, so please suggest.

regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2006

Added on Mar 4 2006

#general-database-discussions

2 comments

317 views