Hi, To export data as a backup of my oracle 8i server I did the following:
1- Executed the script catalog.sql from user "sys" 2- Created a parameter file with following parameters #Userid=system/manager Log=c:\backups\[date folder]\log.txt File=c:\backups\[date folder]\exp_data.dmp Compress=N Consistent=N Direct=Y Full=Y IncType=Complete Indexes=Y Rows=Y 3- Executed the command "EXP system/manager ParFile=C:\Backups\exp_par.dat" This runs fine but gives following errors, the object it points out seem to be system objects, so I hope my own objects and data backup is ok. . 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 . . several lines saying 'about to export ... via direct path', and '. exporting ...' . . 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 I am basically a developer and done this for the first time, my worries are: * Am I missing something, or have I included something which is not required * Is this a healthy backup to import back to 8i * Is it healthy to import to 9i if I first uninstall 8i and then install 9i. * How do I correct the errors. Thanx in advance. Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
