EXP flashing a couple of errors?

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Fri, 01 Feb 2002 05:24:35 -0800
Message-ID: <F001.00403169.20020201045519@fatcity.com>

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: abchaudhary-ho_at_beaconhouse.edu.pk

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: ListGuru_at_fatcity.com (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).

Received on Fri Feb 01 2002 - 07:24:35 CST