Oracle 8.1.7 Export Errors

[TrxaFon]

I am new to being an Oracle DBA, and need to export the database from Oracle 8.1.7 on Windows NT 4.0 so that I can import it into Oracle 10.2 on our new server, a Windows 2003 OS.

I finally got the OEM set-up, and the job permissions were another whole thing. But, having prevailed through those obsticles, it seems I have come to the more technical parts of the export.

Apparently, the export utility is looking for an object that simply does not exist in our database: SYS.AQ$_SUBSCRIBERS--which in turn leads to a few more errors. I have included the beginning and ending sections of the log, below:

Connected to: Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_SYS_EXP_INTERNAL
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
.. a bunch of tables were exported ..
...
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
EXP-00008: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_IMPORT_INTERNAL
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
ORA-06508: PL/SQL: could not find program unit being called
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

Any help that anyone can provide is Greatly appreciated!
Thank you in advance.

triska

 

[Turkbear]

Hi,
Be sure to use the correct EXP version 8.x not the 10x one ( I do not go through OEM, I use the command line version)..

Export must match target database
Import must match target database






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TrxaFon]

The comman line export produces the exact same results. How do you specify that you are exporting in 8i FOR 10g? I don't see how this is possible.

Thank you,
triska

 

[Turkbear]

Hi,
Go to the <Oracle_Home>/bin directory on an 8.x client setup ( or, if installed and accessable, on the 8.x server)

the 10g export utility looks for some views that do not exist in 8.x, so it has problems..

Note: Using a FULL export is not a good idea when moving to a different version..A Schema export of just the data you need is best..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TrxaFon]

Thank you, Turkbear. Just knowing that I should only export the data rather than doing a full export solves my problem!

Thanks again!
triska

 

[Turkbear]

Hi,
No problem, glad to help.
I only use FULL when making export-based backups...








To Paraphrase:"The Help you get is proportional to the Help you give.."