|
-
Hi,
Below is a sample of the log file generated with a full export.
According to jmodic system tablespace is not exported. I am not sure whether all of these are system tables but the ones with $ signs definitly should be.
Also if these are not system tables then can i just go ahead and delete them without affecting the day to day database operation.
Please confirm.
Thanks
Anurag
Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Objects option
PL/SQL Release 8.0.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
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
. exporting object type definitions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table CHAINED_ROWS 1620 rows exported
. . exporting table DEF$_AQCALL 0 rows exported
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALL 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 2 rows exported
. . exporting table EVT_REGISTRY_BACKLOG 0 rows exported
. . exporting table PLAN_TABLE 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 17 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 2 rows exported
. . exporting table SMOSNAMES_X 0 rows exported
. . exporting table SMOWNERLINKS 19 rows exported
. . exporting table SMPACKAGE_S 0 rows exported
. . exporting table SMPARALLELJOB_S 0 rows exported
. . exporting table SMPARALLELOPERATION_S 9 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 1 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 SQLPLUS_PRODUCT_PROFILE 0 rows exported
. . exporting table USER_PROFILE 0 rows exported
. about to export DBSNMP's tables via Conventional Path ...
. about to export MANDA's tables via Conventional Path ...
. . exporting table ADVISOR 906 rows exported
. . exporting table ASSET_DETAIL 5740 rows exported
. . exporting table ASSET_PROPERTY 248 rows exported
. . exporting table ASSET_TYPE 21 rows exported
. . exporting table ATTRIBUTE 7 rows exported
. . exporting table BUSINESS_FOCUS 8 rows exported
. . exporting table COMPANY 7513 rows exported
. . exporting table COMPANY_TYPE 42 rows exported
. . exporting table COMPARABLE_TRANSACTIONS 781 rows exported
. . exporting table CORPORATE_LINE_ITEM 2426 rows expo
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
|