OraFAQ Forum: Server Utilities » Oracle Export Errors!!! Help, please.

Home » RDBMS Server » Server Utilities » Oracle Export Errors!!! Help, please.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Export Errors!!! Help, please. [message #71131]

Thu, 12 September 2002 06:54

Benny
Messages: 8
Registered: March 2002

Junior Member

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - 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 Direct Path ...
EXP-00067: Table DEF$_AQCALL will be exported in conventional path.
. . exporting table DEF$_AQCALL 0 rows exported
EXP-00067: Table DEF$_AQERROR will be exported in conventional path.

Report message to a moderator

Re: Oracle Export Errors!!! Help, please. [message #71132 is a reply to message #71131]

Thu, 12 September 2002 08:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Run catqueue.sql which is in ORACLE_HOME/rdbms/admin while logged into
the database as SYS.
try again.

Report message to a moderator

Is there any danger to run that SQL script? [message #71133 is a reply to message #71132]

Thu, 12 September 2002 08:54

Benny
Messages: 8
Registered: March 2002

Junior Member

I just don't want to damage my live database.

Report message to a moderator

Oracle listener service stops by itself. [message #71839 is a reply to message #71131]

Sun, 19 January 2003 19:15

Marcial Kapuno
Messages: 1
Registered: January 2003

Junior Member

I have a problem. I'm using Oracle 8 Release 8.1.3.4 running on a Windows 2000 using Service Pack 2. The Oracle listener stops by itself. Everytime this happens I have to restart the said service. Could you please help me with this one.

Thank you

Report message to a moderator