exporting problem with 8.0.6 DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: exporting problem with 8.0.6 DB

Hybrid View

  1. #1
    Join Date
    Nov 2001
    Posts
    2

    Angry

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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

  3. #3
    Join Date
    Nov 2001
    Posts
    2

    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
  •  



Click Here to Expand Forum to Full Width