-
Hello,
I'm trying to perform an export using the EXP or EXP80 command:
SET ORACLE_SID=T1
SET ORACLE_HOME=C:\ORANT
EXP80 SYSTEM/MANAGER FILE=T1_EXPORT LOG=T1_EXPORT
I've also executed the catexp.sql file but still running into the same problem.
I get these errors:
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 787
ORA-06512: at "SYS.DBMS_SQL", line 328
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Please HELP!!!
Thanks
-
what is the version of your Oracle?
how did you run the catexp.sql?
as system or sys?
a full text of the screen helps identify the problem..
try to put that..
I mean from exp / exp80 onwards mark,copy and paste..it looks u r on windows
sonofsita
http://www.ordba.net
-
Sorry, let me clarify
Sorry, let me elaborate:
- I using Oracle 8.0.6.
- I ran catexp.sql as sys
- I'm using Windows NT 4.0
- The errors were received when I ran the export command:
EXP80 SYSTEM/MANAGER FILE=T1_EXPORT LOG=T1_EXPORT
Connected to: Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified users ...
. exporting foreign function library names for user SYSTEM
. exporting object type definitions for user SYSTEM
About to export SYSTEM's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table ASSOC_BIN_ENTRIES_V4 0 rows exported
. . exporting table ASSOC_ENTRIES_V4 0 rows exported
. . exporting table ASSOC_STR_ENTRIES_V4 0 rows exported
. . exporting table ASSOC_V4 1 rows exported
. . exporting table BLKPOTMP 0 rows exported
. . exporting table CMDEBIT 0 rows exported
. . exporting table CMHEADER 6 rows exported
. . exporting table CMTRANS 7 rows exported
. . exporting table DBCRTMP 601 rows exported
. . exporting table DEF$_AQCALL 0 rows exported
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported
. . exporting table DEF$_ERROR 0 rows exported
. . exporting table DEF$_LOB 0 rows exported
. . exporting table DEF$_ORIGIN 0 rows exported
. . exporting table DEF$_PROPAGATOR 0 rows exported
. . exporting table DEF$_TEMP$LOB 0 rows exported
. . exporting table EVT_CARRIER_CONFIGURATION 0 rows exported
. . exporting table EVT_DEST_PROFILE 0 rows exported
. . exporting table EVT_HISTORY 0 rows exported
. . exporting table EVT_INSTANCE 0 rows exported
. . exporting table EVT_MAIL_CONFIGURATION 0 rows exported
. . exporting table EVT_MONITOR_NODE 0 rows exported
. . exporting table EVT_NOTIFY_STATUS 0 rows exported
. . exporting table EVT_OPERATORS 0 rows exported
. . exporting table EVT_OPERATORS_ADDITIONAL 0 rows exported
. . exporting table EVT_OPERATORS_SYSTEMS 0 rows exported
. . exporting table EVT_OUTSTANDING 0 rows exported
. . exporting table EVT_PROFILE 5 rows exported
. . exporting table EVT_PROFILE_EVENTS 11 rows exported
. . exporting table EVT_REGISTRY 0 rows exported
. . exporting table EVT_REGISTRY_BACKLOG 0 rows exported
. . exporting table GLTEMP 80 rows exported
. . exporting table INSTANCE 1 rows exported
. . exporting table INSTANCE_INFO 0 rows exported
. . exporting table MONITORING 0 rows exported
. . exporting table NEWENGLANDACCTS 1434 rows exported
. . exporting table NODE_V4 0 rows exported
. . exporting table REPCAT$_AUDIT_ATTRIBUTE 2 rows exported
. . exporting table REPCAT$_AUDIT_COLUMN 0 rows exported
. . exporting table REPCAT$_COLUMN_GROUP 0 rows exported
. . exporting table REPCAT$_CONFLICT 0 rows exported
. . exporting table REPCAT$_DDL 0 rows exported
. . exporting table REPCAT$_GENERATED 0 rows exported
. . exporting table REPCAT$_GROUPED_COLUMN 0 rows exported
. . exporting table REPCAT$_KEY_COLUMNS 0 rows exported
. . exporting table REPCAT$_PARAMETER_COLUMN 0 rows exported
. . exporting table REPCAT$_PRIORITY 0 rows exported
. . exporting table REPCAT$_PRIORITY_GROUP 0 rows exported
. . exporting table REPCAT$_REPCAT 0 rows exported
. . exporting table REPCAT$_REPCATLOG 0 rows exported
. . exporting table REPCAT$_REPCOLUMN 0 rows exported
. . exporting table REPCAT$_REPOBJECT 0 rows exported
. . exporting table REPCAT$_REPPROP 0 rows exported
. . exporting table REPCAT$_REPSCHEMA 0 rows exported
. . exporting table REPCAT$_RESOLUTION 0 rows exported
. . exporting table REPCAT$_RESOLUTION_METHOD 16 rows exported
. . exporting table REPCAT$_RESOLUTION_STATISTICS 0 rows exported
. . exporting table REPCAT$_RESOL_STATS_CONTROL 0 rows exported
. . exporting table REPCAT$_SNAPGROUP 0 rows exported
. . exporting table SMACTUALPARAMETER_S 0 rows exported
. . exporting table SMAGENTJOB_S 0 rows exported
. . exporting table SMARCHIVE_S 0 rows exported
. . exporting table SMBREAKABLELINKS 0 rows exported
. . exporting table SMCLIQUE 0 rows exported
. . exporting table SMCONFIGURATION 1 rows exported
. . exporting table SMCONSOLESOSETTING_S 0 rows exported
. . exporting table SMDATABASE_S 0 rows exported
. . exporting table SMDBAUTH_S 0 rows exported
. . exporting table SMDEFAUTH_S 0 rows exported
. . exporting table SMDEPENDENTLINKS 0 rows exported
. . exporting table SMDISTRIBUTIONSET_S 0 rows exported
. . exporting table SMFOLDER_S 0 rows exported
. . exporting table SMFORMALPARAMETER_S 0 rows exported
. . exporting table SMGLOBALCONFIGURATION_S 0 rows exported
. . exporting table SMHOSTAUTH_S 0 rows exported
. . exporting table SMHOST_S 0 rows exported
. . exporting table SMINSTALLATION_S 0 rows exported
. . exporting table SMLOGMESSAGE_S 0 rows exported
. . exporting table SMMONTHLYENTRY_S 0 rows exported
. . exporting table SMMONTHWEEKENTRY_S 0 rows exported
. . exporting table SMMOWNERLINKS 0 rows exported
. . exporting table SMOMSTRING_S 0 rows exported
. . exporting table SMOSNAMES_X 0 rows exported
. . exporting table SMOWNERLINKS 0 rows exported
. . exporting table SMPACKAGE_S 0 rows exported
. . exporting table SMPARALLELJOB_S 0 rows exported
. . exporting table SMPARALLELOPERATION_S 0 rows exported
. . exporting table SMPARALLELSTATEMENT_S 0 rows exported
. . exporting table SMPRODUCTATTRIBUTE_S 0 rows exported
. . exporting table SMPRODUCT_S 0 rows exported
. . exporting table SMP_AD_ADDRESSES_ 0 rows exported
. . exporting table SMP_AD_DISCOVERED_NODES_ 0 rows exported
. . exporting table SMP_AD_NODES_ 0 rows exported
. . exporting table SMP_AD_PARMS_ 0 rows exported
. . exporting table SMP_AUTO_DISCOVERY_ITEM_ 0 rows exported
. . exporting table SMP_AUTO_DISCOVERY_PARMS_ 0 rows exported
. . exporting table SMP_BLOB_ 9 rows exported
. . exporting table SMP_BRM_ACTIVE_JOB_ 0 rows exported
. . exporting table SMP_BRM_CHANNEL_DEVICE_ 0 rows exported
. . exporting table SMP_BRM_DEFAULT_CHANNEL_ 0 rows exported
. . exporting table SMP_BRM_RC_CONNECT_STRING_ 0 rows exported
. . exporting table SMP_BRM_SAVED_JOB_ 0 rows exported
. . exporting table SMP_BRM_TEMP_SCRIPTS_ 0 rows exported
. . exporting table SMP_CREDENTIALS$ 0 rows exported
. . exporting table SMP_EBU_ACTIVE_JOB_ 0 rows exported
. . exporting table SMP_EBU_SAVED_JOB_ 0 rows exported
. . exporting table SMP_JOB_ 0 rows exported
. . exporting table SMP_JOB_EVENTLIST_ 0 rows exported
. . exporting table SMP_JOB_HISTORY_ 0 rows exported
. . exporting table SMP_JOB_INSTANCE_ 0 rows exported
. . exporting table SMP_JOB_LIBRARY_ 0 rows exported
. . exporting table SMP_JOB_TASK_INSTANCE_ 0 rows exported
. . exporting table SMP_LONG_TEXT_ 0 rows exported
. . exporting table SMP_REP_EXEC_STAT 0 rows exported
. . exporting table SMP_REP_VERSION 2 rows exported
. . exporting table SMP_SERVICES 2 rows exported
. . exporting table SMP_SERVICE_DATA_ 0 rows exported
. . exporting table SMP_SERVICE_GROUP_DEFN_ 0 rows exported
. . exporting table SMP_SERVICE_GROUP_ITEM_ 0 rows exported
. . exporting table SMP_SERVICE_ITEM_ 0 rows exported
. . exporting table SMP_UPDATESERVICES_CALLED_ 0 rows exported
. . exporting table SMP_USER_DETAILS 0 rows exported
. . exporting table SMP_VAB_ACTIVE_JOB_ 0 rows exported
. . exporting table SMP_VAB_SAVED_JOB_ 0 rows exported
. . exporting table SMP_VAR_LIST_DATABASES_ 0 rows exported
. . exporting table SMRELEASE_S 0 rows exported
. . exporting table SMRUN_S 0 rows exported
. . exporting table SMSCHEDULE_S 0 rows exported
. . exporting table SMSHAREDORACLECLIENT_S 0 rows exported
. . exporting table SMSHAREDORACLECONFIGURATION_S 0 rows exported
. . exporting table SMTABLESPACE_S 0 rows exported
. . exporting table SMVCENDPOINT_S 0 rows exported
. . exporting table SMWEEKLYENTRY_S 0 rows exported
. . exporting table SYSTWODB_BLKPO 0 rows exported
. . exporting table TESTBLKPOTMP 70 rows exported
. . exporting table TESTDBCRTMP 70 rows exported
. . exporting table TESTGLTEMP 0 rows exported
. . exporting table TIBCOMONITOR 11 rows exported
. . exporting table TIBCO_DASHBOARD 3 rows exported
. . exporting table TIBCO_DB 0 rows exported
. . exporting table TRADER 16 rows exported
. . exporting table TRANSDDADETAIL 3 rows exported
. . exporting table URBCREDIT 4 rows exported
. . exporting table URBDEBIT 2 rows exported
. . exporting table VERSION 1 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting referential integrity constraints
. exporting triggers
. 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 787
ORA-06512: at "SYS.DBMS_SQL", line 328
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|