DATA PUMP (Part I) : Architecture.
July 10, 2012
Leave a comment
Its been a long time since I had posted on the blog. I was away from writing and could not resist more to write a post. So here I am with post on DATAPUMP. I know it’s been quite sometime for DATAPUMP being used as a replacement for conventional exp/imp tools. There are certain enhancements in DATAPUMP which cannot be achieved using traditional exp/imp. One of the most important one is the “Restartability” of the exp/imp process.I will try to go through most of the useful features (with examples) which are new in Oracle 10g and above.
Movement of data across the databases and servers is the integral part of the enterprise architecture. There has always been the need to move the subset of data from one database to another database or from one server to another. This was achieved using exp/imp tools of Oracle in earlier versions. With Oracle 10g, we have been provided with the DATAPUMP utility, which provides the fast parallel bulk data and metadata movement between databases… simple and fast. With DATAPUMP Oracle has introduced a setup, which the utility creates by itself. The various components of the setup are described below.
Architecture of the Data Pump:
In oracle 10g the Data Pump (server side utility) does all the work. Earlier the exp/imp utilities were executed from the client and the dump file was stored on the client. With Data Pump the dump files are stored on the server. The Data Pump architecture consists of following components.
1. Data Pump API
2. Client Tools
3. Master Control Process
4. Worker Process
Data Pump API : DBMS_DATAPUMP is the API for Data Pump. This API is the engine using which the jobs are created and monitored.
Client Tools : As in the earlier version, we had exp/imp tools, now we have data pump tools expdp and impdp. These client side tools use the DBMS_DATAPUMP API to execute and monitor the jobs.
Master Control Process : Master Control Process (MCP) controls the execution of the data pump job. There is one MCP per job. It maintains the control information like job name, job status, file information etc. in the master table, which has the same name as the job name. The details in master table can be used to restart a job. Once the job completes, the master table is dropped.
Worker Process : Worker process are created by the MCP depending on the PARALLEL parameter. The worker process performs the tasks as requested the MCP process which is loading/unloading of data or metadata. The worker process maintains the details in the master table which can be used to restart the job.
Perform an export using Data Pump :
Conventionally the earlier version of Oracle used exp/imp tools. With Data Pump, new tools expdp/impdp were introduced to perform an export or import. Let’s see how we can use the new expdp client to perform an export of the database. Since the expdp client is using the DBMS_DATAPUMP API to perform the export, it will need a space to store the dump. Hence we need to have a Oracle Directory which is passed as parameter to expdp client. The API will make use of this Oracle Directory and store the dump in the specified OS location.
So lets first create a directory in Oracle
SQL> create directory data_pump as '/u01/export'; directory created.
Grant the required privileges to the user performing the export so that the user can read from and write to the directory location.
SQL> grant read, write on directory data_pump to expuser; grant succeeded.
Grant the privileges to the user so that the user can perform the export or import of the database.
SQL> grant EXP_FULL_DATABASE to expuser; grant succeeded. SQL> grant IMP_FULL_DATABASE to expuser; grant succeeded.
Once the above mentioned steps are performed and required privileges have been granted to the user, we are ready to perform the export.
Execute the basic expdp command to take a full database export dump.
bash-3.2$ expdp directory=data_pump dumpfile=expFULL.dmp logfile=expFULL.log full=Y Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 10 July, 2012 18:17:09 Copyright (c) 2003, 2005, Oracle. All rights reserved. Username: expuser/expuser Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Starting "SYSTEM"."SYS_EXPORT_FULL_01": expuser/******** directory=data_pump dumpfile=expFULL.dmp logfile=expFULL.log full=Y Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-39139: Data Pump does not support XMLSchema objects. TABLE_DATA:"OE"."PURCHASEORDER" will be skipped. Total estimation using BLOCKS method: 79.68 MB Processing object type DATABASE_EXPORT/TABLESPACE Processing object type DATABASE_EXPORT/PROFILE Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/SCHEMA/USER Processing object type DATABASE_EXPORT/ROLE Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA Processing object type DATABASE_EXPORT/RESOURCE_COST Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/CONTEXT Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW Processing object type DATABASE_EXPORT/SCHEMA/JOB Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA . . exported "SCOTT"."T" 18.51 MB 198692 rows . . exported "SH"."CUSTOMERS" 9.850 MB 55500 rows . . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 695.9 KB 4500 rows . . exported "OE"."PRODUCT_DESCRIPTIONS" 2.379 MB 8640 rows . . exported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows . . exported "SH"."SALES":"SALES_Q1_1999" 2.070 MB 64186 rows . . exported "SH"."SALES":"SALES_Q3_2001" 2.129 MB 65769 rows . . exported "SH"."SALES":"SALES_Q1_2000" 2.011 MB 62197 rows . . exported "SH"."SALES":"SALES_Q1_2001" 1.964 MB 60608 rows . . exported "SH"."SALES":"SALES_Q2_2001" 2.050 MB 63292 rows . . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows . . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows . . exported "SH"."SALES":"SALES_Q2_2000" 1.801 MB 55515 rows . . exported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows . . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows . . exported "SH"."SALES":"SALES_Q4_2000" 1.813 MB 55984 rows . . exported "SH"."SALES":"SALES_Q2_1999" 1.753 MB 54233 rows . . exported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows . . exported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows . . exported "SYSMAN"."MGMT_METRICS" 579.4 KB 2707 rows . . exported "PM"."ONLINE_MEDIA" 39.21 KB 9 rows . . exported "PM"."PRINT_MEDIA" 186.4 KB 4 rows . . exported "SH"."SALES":"SALES_Q2_1998" 1.159 MB 35758 rows . . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.3 KB 11266 rows . . exported "OE"."LINEITEM_TABLE" 283.5 KB 2232 rows . . exported "SH"."PROMOTIONS" 57.85 KB 503 rows . . exported "SH"."TIMES" 377.2 KB 1826 rows . . exported "SYSMAN"."MGMT_HC_OS_COMPONENTS" 271.7 KB 993 rows . . exported "SYSMAN"."MGMT_HC_VENDOR_SW_COMPONENTS" 271.7 KB 993 rows . . exported "SYSMAN"."MGMT_JOB_CRED_PARAMS" 11.69 KB 18 rows . . exported "OE"."CUSTOMERS" 75.21 KB 319 rows . . exported "OE"."WAREHOUSES" 11.64 KB 9 rows . . exported "SH"."COSTS":"COSTS_Q4_2001" 277.8 KB 9011 rows . . exported "SYSMAN"."MGMT_JOB_PROP_PARAMS" 8.820 KB 12 rows . . exported "SYSMAN"."MGMT_JOB_STEP_PARAMS" 127.3 KB 1128 rows . . exported "SYSMAN"."MGMT_METRICS_RAW" 331.4 KB 4762 rows . . exported "PM"."TEXTDOCS_NESTEDTAB" 87.35 KB 12 rows . . exported "SH"."COSTS":"COSTS_Q1_1999" 183.0 KB 5884 rows . . exported "SH"."COSTS":"COSTS_Q1_2001" 227.3 KB 7328 rows . . exported "SH"."COSTS":"COSTS_Q2_2001" 184.0 KB 5882 rows . . exported "SH"."COSTS":"COSTS_Q3_2001" 233.9 KB 7545 rows . . exported "SYSMAN"."MGMT_JOB_SCHEDULE" 9.437 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_SEC_INFO" 8.046 KB 4 rows . . exported "SYSMAN"."MGMT_JOB_USER_PARAMS" 6.210 KB 1 rows . . exported "SYSMAN"."MGMT_SEC_INFO" 5.851 KB 1 rows . . exported "OE"."PRODUCT_INFORMATION" 71.73 KB 288 rows . . exported "OE"."ACTION_TABLE" 14.87 KB 132 rows . . exported "SH"."COSTS":"COSTS_Q1_1998" 138.9 KB 4411 rows . . exported "SH"."COSTS":"COSTS_Q1_2000" 120.0 KB 3772 rows . . exported "SH"."COSTS":"COSTS_Q2_1998" 78.96 KB 2397 rows . . exported "SH"."COSTS":"COSTS_Q2_1999" 132.0 KB 4179 rows . . exported "SH"."COSTS":"COSTS_Q2_2000" 118.4 KB 3715 rows . . exported "SH"."COSTS":"COSTS_Q3_1998" 130.5 KB 4129 rows . . exported "SH"."COSTS":"COSTS_Q3_1999" 136.8 KB 4336 rows . . exported "SH"."COSTS":"COSTS_Q3_2000" 150.9 KB 4798 rows . . exported "SH"."COSTS":"COSTS_Q4_1998" 144.1 KB 4577 rows . . exported "SH"."COSTS":"COSTS_Q4_1999" 158.5 KB 5060 rows . . exported "SH"."COSTS":"COSTS_Q4_2000" 159.7 KB 5088 rows . . exported "SYSMAN"."MGMT_ARU_PRODUCT_RELEASE_MAP" 39.29 KB 2621 rows . . exported "SYSMAN"."MGMT_CURRENT_METRICS" 32.47 KB 401 rows . . exported "SYSMAN"."MGMT_DB_INIT_PARAMS_ECM" 33.45 KB 516 rows . . exported "SYSMAN"."MGMT_ECM_SNAPSHOT_MD_COLUMNS" 49.21 KB 506 rows . . exported "SYSMAN"."MGMT_HC_VENDOR_SW_SUMMARY" 83.24 KB 993 rows . . exported "SYSMAN"."MGMT_JOB_EXECPLAN" 45.92 KB 366 rows . . exported "SYSMAN"."MGMT_JOB_PARAM_SOURCE" 28.59 KB 140 rows . . exported "SYSMAN"."MGMT_JOB_SQL_PARAMS" 6.296 KB 3 rows . . exported "SYSMAN"."MGMT_JOB_SUBST_PARAMS" 5.671 KB 3 rows . . exported "SYSMAN"."PARAM_VALUES_TAB" 9.671 KB 44 rows . . exported "SYSMAN"."MGMT_METRICS_1HOUR" 78.56 KB 855 rows . . exported "SYSMAN"."MGMT_POLICY_RULE" 57.66 KB 55 rows . . exported "SYSMAN"."MGMT_SEVERITY" 59.10 KB 205 rows . . exported "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" 33.10 KB 452 rows . . exported "HR"."COUNTRIES" 6.085 KB 25 rows . . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows . . exported "HR"."EMPLOYEES" 15.76 KB 107 rows . . exported "HR"."JOBS" 6.609 KB 19 rows . . exported "HR"."JOB_HISTORY" 6.585 KB 10 rows . . exported "HR"."LOCATIONS" 7.710 KB 23 rows . . exported "HR"."REGIONS" 5.296 KB 4 rows . . exported "IX"."AQ$_ORDERS_QUEUETABLE_S" 7.835 KB 4 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_S" 8.031 KB 1 rows . . exported "OE"."CATEGORIES_TAB" 13.12 KB 22 rows . . exported "OE"."SUBCATEGORY_REF_LIST_NESTEDTAB" 6.406 KB 21 rows . . exported "OE"."PRODUCT_REF_LIST_NESTEDTAB" 12.32 KB 288 rows . . exported "OE"."INVENTORIES" 21.39 KB 1112 rows . . exported "OE"."ORDERS" 11.64 KB 105 rows . . exported "OE"."ORDER_ITEMS" 20.41 KB 665 rows . . exported "OE"."PROMOTIONS" 5.320 KB 2 rows . . exported "OLAPSYS"."CWM$CLASSIFICATION" 12.49 KB 42 rows . . exported "OLAPSYS"."CWM$CLASSIFICATIONENTRY" 17.42 KB 66 rows . . exported "OLAPSYS"."CWM$CLASSIFICATIONTYPE" 11.03 KB 15 rows . . exported "OLAPSYS"."CWM$CUBE" 12.32 KB 2 rows . . exported "OLAPSYS"."CWM$CUBEDIMENSIONUSE" 12.45 KB 9 rows . . exported "OLAPSYS"."CWM$DIMENSION" 12.93 KB 5 rows . . exported "OLAPSYS"."CWM$DIMENSIONATTRIBUTE" 16.24 KB 23 rows . . exported "OLAPSYS"."CWM$DOMAIN" 13.10 KB 21 rows . . exported "OLAPSYS"."CWM$FACTLEVELGROUP" 7.632 KB 2 rows . . exported "OLAPSYS"."CWM$FACTLEVELUSE" 10.92 KB 9 rows . . exported "OLAPSYS"."CWM$FACTTABLEMAP" 10.21 KB 2 rows . . exported "OLAPSYS"."CWM$FACTUSE" 17.38 KB 4 rows . . exported "OLAPSYS"."CWM$FUNCTION" 11.15 KB 14 rows . . exported "OLAPSYS"."CWM$FUNCTIONUSE" 16.39 KB 4 rows . . exported "OLAPSYS"."CWM$HIERARCHY" 10.95 KB 7 rows . . exported "OLAPSYS"."CWM$ITEMMAP" 12.29 KB 59 rows . . exported "OLAPSYS"."CWM$ITEMUSE" 21.14 KB 118 rows . . exported "OLAPSYS"."CWM$LEVEL" 14.72 KB 27 rows . . exported "OLAPSYS"."CWM$LEVELATTRIBUTE" 20.87 KB 67 rows . . exported "OLAPSYS"."CWM$MEASURE" 14.35 KB 4 rows . . exported "OLAPSYS"."CWM$MEASUREDIMENSIONUSE" 8.757 KB 4 rows . . exported "OLAPSYS"."CWM$MODEL" 10.88 KB 3 rows . . exported "OLAPSYS"."CWM$OBJECTTYPE" 11.10 KB 15 rows . . exported "OLAPSYS"."CWM$PARAMETER" 16.10 KB 5 rows . . exported "OLAPSYS"."CWM$PROJECT" 9.484 KB 3 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADPARM" 5.875 KB 1 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADTYPE" 5.640 KB 2 rows . . exported "OLAPSYS"."CWM2$AWDIMLOADPARM" 5.960 KB 4 rows . . exported "OLAPSYS"."CWM2$AWDIMLOADTYPE" 5.656 KB 2 rows . . exported "OLAPSYS"."CWM2$MRALL_DESCRIPTORS" 6.710 KB 41 rows . . exported "SCOTT"."DEPT" 5.656 KB 4 rows . . exported "SCOTT"."EMP" 7.820 KB 14 rows . . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows . . exported "SH"."CAL_MONTH_SALES_MV" 6.125 KB 48 rows . . exported "SH"."CHANNELS" 6.687 KB 5 rows . . exported "SH"."COUNTRIES" 9.265 KB 23 rows . . exported "SH"."PRODUCTS" 24.09 KB 72 rows . . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S" 7.781 KB 2 rows . . exported "SYSMAN"."ESM_COLLECTION" 7.312 KB 46 rows . . exported "SYSMAN"."MGMT_ADMIN_LICENSES" 5 KB 5 rows . . exported "SYSMAN"."MGMT_ARU_FAMILY_PRODUCT_MAP" 12.41 KB 579 rows . . exported "SYSMAN"."MGMT_ARU_LANGUAGES" 5.921 KB 37 rows . . exported "SYSMAN"."MGMT_ARU_OUI_COMPONENTS" 18.12 KB 319 rows . . exported "SYSMAN"."MGMT_ARU_PLATFORMS" 7.968 KB 49 rows . . exported "SYSMAN"."MGMT_ARU_PRODUCTS" 24.64 KB 524 rows . . exported "SYSMAN"."MGMT_ARU_RELEASES" 9.804 KB 301 rows . . exported "SYSMAN"."MGMT_AVAILABILITY" 6.632 KB 11 rows . . exported "SYSMAN"."MGMT_AVAILABILITY_MARKER" 5.75 KB 6 rows . . exported "SYSMAN"."MGMT_BLACKOUT_PROXY_TARGETS" 5.062 KB 6 rows . . exported "SYSMAN"."MGMT_BLACKOUT_REASON" 5.265 KB 1 rows . . exported "SYSMAN"."MGMT_COLLECTION_PROPERTIES" 6.687 KB 6 rows . . exported "SYSMAN"."MGMT_CREATED_USERS" 5.695 KB 4 rows . . exported "SYSMAN"."MGMT_CREDENTIALS2" 7.085 KB 3 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_SETS" 8.117 KB 10 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_SET_COLUMNS" 8.835 KB 23 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_TYPES" 6.937 KB 6 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_TYPE_COLUMNS" 8.531 KB 13 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_TYPE_REF" 7.242 KB 2 rows . . exported "SYSMAN"."MGMT_CURRENT_AVAILABILITY" 6.125 KB 6 rows . . exported "SYSMAN"."MGMT_CURRENT_METRIC_ERRORS" 7.093 KB 1 rows . . exported "SYSMAN"."MGMT_CURRENT_SEVERITY" 10.26 KB 3 rows . . exported "SYSMAN"."MGMT_DB_CONTROLFILES_ECM" 7.5 KB 4 rows . . exported "SYSMAN"."MGMT_DB_DATAFILES_ECM" 8.617 KB 12 rows . . exported "SYSMAN"."MGMT_DB_DBNINSTANCEINFO_ECM" 8.070 KB 2 rows . . exported "SYSMAN"."MGMT_DB_HDM_METRIC_HELPER" 5.601 KB 1 rows . . exported "SYSMAN"."MGMT_DB_LICENSE_ECM" 6.554 KB 2 rows . . exported "SYSMAN"."MGMT_DB_RECTSSETTINGS_ECM" 6.375 KB 2 rows . . exported "SYSMAN"."MGMT_DB_REDOLOGS_ECM" 8.843 KB 12 rows . . exported "SYSMAN"."MGMT_DB_ROLLBACK_SEGS_ECM" 10.00 KB 2 rows . . exported "SYSMAN"."MGMT_DB_SGA_ECM" 6.296 KB 18 rows . . exported "SYSMAN"."MGMT_DB_TABLESPACES_ECM" 9.75 KB 12 rows . . exported "SYSMAN"."MGMT_DELTA_SNAP" 8.976 KB 5 rows . . exported "SYSMAN"."MGMT_ECM_ARU_MAP" 7.304 KB 22 rows . . exported "SYSMAN"."MGMT_ECM_GEN_SNAPSHOT" 11.49 KB 16 rows . . exported "SYSMAN"."MGMT_ECM_RESOURCES" 6.523 KB 14 rows . . exported "SYSMAN"."MGMT_ECM_SNAPSHOT" 8.539 KB 1 rows . . exported "SYSMAN"."MGMT_ECM_SNAPSHOT_MD_TABLES" 12.37 KB 77 rows . . exported "SYSMAN"."MGMT_ECM_SNAPSHOT_METADATA" 12.60 KB 34 rows . . exported "SYSMAN"."MGMT_ECM_SNAP_COMPONENT_INFO" 6.804 KB 4 rows . . exported "SYSMAN"."MGMT_EMCRYPTO_SEED" 4.960 KB 1 rows . . exported "SYSMAN"."MGMT_EMD_PING" 8.812 KB 1 rows . . exported "SYSMAN"."MGMT_FAILOVER_CALLBACKS" 5.023 KB 2 rows . . exported "SYSMAN"."MGMT_HA_INFO_ECM" 6.578 KB 2 rows . . exported "SYSMAN"."MGMT_HA_MTTR" 5.585 KB 1 rows . . exported "SYSMAN"."MGMT_HA_RMAN_CONFIG_ECM" 5.632 KB 2 rows . . exported "SYSMAN"."MGMT_HC_CPU_DETAILS" 6.867 KB 1 rows . . exported "SYSMAN"."MGMT_HC_FS_MOUNT_DETAILS" 6.273 KB 2 rows . . exported "SYSMAN"."MGMT_HC_HARDWARE_MASTER" 8.468 KB 1 rows . . exported "SYSMAN"."MGMT_HC_OS_PROPERTIES" 30.63 KB 398 rows . . exported "SYSMAN"."MGMT_HC_OS_SUMMARY" 7.25 KB 1 rows . . exported "SYSMAN"."MGMT_HC_SYSTEM_SUMMARY" 6.859 KB 1 rows . . exported "SYSMAN"."MGMT_INV_COMPONENT" 35.61 KB 109 rows . . exported "SYSMAN"."MGMT_INV_CONTAINER" 7.007 KB 2 rows . . exported "SYSMAN"."MGMT_INV_DEPENDENCY_RULE" 13.69 KB 219 rows . . exported "SYSMAN"."MGMT_JOB" 9.625 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_COMMAND" 7.656 KB 30 rows . . exported "SYSMAN"."MGMT_JOB_EVENT" 5.296 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_EXECUTION" 12.83 KB 3 rows . . exported "SYSMAN"."MGMT_JOB_EXEC_SUMMARY" 9.453 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_HISTORY" 12.52 KB 3 rows . . exported "SYSMAN"."MGMT_JOB_NESTED_JOB_TARGETS" 6.320 KB 4 rows . . exported "SYSMAN"."MGMT_JOB_PURGE_CRITERIA" 5.906 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_PURGE_POLICIES" 5.304 KB 2 rows . . exported "SYSMAN"."MGMT_JOB_PURGE_VALUES" 5.671 KB 1 rows . . exported "SYSMAN"."MGMT_JOB_SINGLE_TARGET_TYPES" 5.437 KB 7 rows . . exported "SYSMAN"."MGMT_JOB_TYPE_DISPLAY_INFO" 7.085 KB 31 rows . . exported "SYSMAN"."MGMT_JOB_TYPE_DISPLAY_PARAM" 10.73 KB 172 rows . . exported "SYSMAN"."MGMT_JOB_TYPE_INFO" 9.523 KB 53 rows . . exported "SYSMAN"."MGMT_JOB_TYPE_URI_INFO" 9.234 KB 61 rows . . exported "SYSMAN"."MGMT_JOB_VALUE_PARAMS" 6.835 KB 23 rows . . exported "SYSMAN"."MGMT_LICENSABLE_TARGET_TYPES" 5.570 KB 11 rows . . exported "SYSMAN"."MGMT_LICENSES" 5.562 KB 1 rows . . exported "SYSMAN"."MGMT_LICENSE_DEFINITIONS" 7.015 KB 5 rows . . exported "SYSMAN"."MGMT_LOGIN_ASSISTANTS" 5.765 KB 2 rows . . exported "SYSMAN"."MGMT_MASTER_CHANGED_CALLBACK" 5.617 KB 1 rows . . exported "SYSMAN"."MGMT_METADATA_SETS" 7.148 KB 26 rows . . exported "SYSMAN"."MGMT_METRICS_1DAY" 11.35 KB 46 rows . . exported "SYSMAN"."MGMT_METRICS_COMPOSITE_KEYS" 7.398 KB 12 rows . . exported "SYSMAN"."MGMT_METRICS_EXT" 9.171 KB 20 rows . . exported "SYSMAN"."MGMT_METRIC_COLLECTIONS" 22.30 KB 116 rows . . exported "SYSMAN"."MGMT_METRIC_COLLECTIONS_REP" 6.078 KB 9 rows . . exported "SYSMAN"."MGMT_METRIC_DEPENDENCY_DEF" 7 KB 13 rows . . exported "SYSMAN"."MGMT_METRIC_ERRORS" 7.085 KB 1 rows . . exported "SYSMAN"."MGMT_METRIC_THRESHOLDS" 26.67 KB 225 rows . . exported "SYSMAN"."MGMT_NOTIFY_PROFILES" 6.25 KB 3 rows . . exported "SYSMAN"."MGMT_NOTIFY_QUEUES" 5.531 KB 24 rows . . exported "SYSMAN"."MGMT_NOTIFY_RULES" 12.72 KB 6 rows . . exported "SYSMAN"."MGMT_NOTIFY_RULE_CONFIGS" 10.13 KB 30 rows . . exported "SYSMAN"."MGMT_OMS_PARAMETERS" 6.390 KB 7 rows . . exported "SYSMAN"."MGMT_PARAMETERS" 6.406 KB 6 rows . . exported "SYSMAN"."MGMT_PERFORMANCE_NAMES" 7.960 KB 43 rows . . exported "SYSMAN"."MGMT_POLICY_GROUP" 8.593 KB 6 rows . . exported "SYSMAN"."MGMT_POLICY_RULE_CRITERIA" 6.578 KB 7 rows . . exported "SYSMAN"."MGMT_POLICY_RULE_DEF_COLUMNS" 16.86 KB 111 rows . . exported "SYSMAN"."MGMT_POLICY_SNAPSHOT_CRITERIA" 6.437 KB 18 rows . . exported "SYSMAN"."MGMT_POLICY_TARGET_CRITERIA" 6.546 KB 9 rows . . exported "SYSMAN"."MGMT_POLICY_VIOLATIONS" 6.414 KB 8 rows . . exported "SYSMAN"."MGMT_POLICY_VIOLATION_ROWS" 8.671 KB 19 rows . . exported "SYSMAN"."MGMT_POLICY_VIOLATION_VALUES" 8.054 KB 41 rows . . exported "SYSMAN"."MGMT_PRIVS" 7.539 KB 19 rows . . exported "SYSMAN"."MGMT_PRIV_GRANTS" 7.023 KB 10 rows . . exported "SYSMAN"."MGMT_PRIV_INCLUDES" 5.617 KB 12 rows . . exported "SYSMAN"."MGMT_PURGE_POLICY" 9.203 KB 12 rows . . exported "SYSMAN"."MGMT_PURGE_POLICY_GROUP" 5.867 KB 7 rows . . exported "SYSMAN"."MGMT_PURGE_POLICY_TARGET_STATE" 9.164 KB 52 rows . . exported "SYSMAN"."MGMT_REBUILD_INDEXES" 5.585 KB 1 rows . . exported "SYSMAN"."MGMT_ROLES" 5.25 KB 1 rows . . exported "SYSMAN"."MGMT_ROLE_GRANTS" 5.960 KB 1 rows . . exported "SYSMAN"."MGMT_SPACE_METRICS" 7.570 KB 1 rows . . exported "SYSMAN"."MGMT_STRING_METRIC_HISTORY" 19.48 KB 141 rows . . exported "SYSMAN"."MGMT_TARGETS" 14.04 KB 6 rows . . exported "SYSMAN"."MGMT_TARGET_ADD_CALLBACKS" 5.304 KB 1 rows . . exported "SYSMAN"."MGMT_TARGET_CREDENTIALS" 5.937 KB 1 rows . . exported "SYSMAN"."MGMT_TARGET_DELETE_CALLBACKS" 5.234 KB 7 rows . . exported "SYSMAN"."MGMT_TARGET_DELETE_EXCEPTIONS" 5.156 KB 8 rows . . exported "SYSMAN"."MGMT_TARGET_PROPERTIES" 9.703 KB 65 rows . . exported "SYSMAN"."MGMT_TARGET_PROP_DEFS" 9.148 KB 21 rows . . exported "SYSMAN"."MGMT_TARGET_ROLLUP_TIMES" 11.94 KB 132 rows . . exported "SYSMAN"."MGMT_TARGET_TYPES" 7.507 KB 23 rows . . exported "SYSMAN"."MGMT_TARGET_TYPE_COMPONENT_MAP" 6.046 KB 4 rows . . exported "SYSMAN"."MGMT_TYPE_PROPERTIES" 6.523 KB 26 rows . . exported "SYSMAN"."MGMT_USER_CALLBACKS" 5.390 KB 4 rows . . exported "SYSMAN"."MGMT_USER_CONTEXT" 5.617 KB 4 rows . . exported "SYSMAN"."MGMT_USER_FOLDERS" 6.343 KB 18 rows . . exported "SYSMAN"."MGMT_USER_JOBS" 5.25 KB 1 rows . . exported "SYSMAN"."MGMT_USER_TYPE_METRIC_PREFS" 6.171 KB 7 rows . . exported "SYSMAN"."MGMT_VERSIONS" 6.242 KB 2 rows . . exported "SYSMAN"."MGMT_VIEW_USER_CREDENTIALS" 5.335 KB 1 rows . . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 5.960 KB 2 rows . . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.515 KB 28 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.656 KB 19 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.304 KB 3 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 5.921 KB 2 rows . . exported "IX"."AQ$_ORDERS_QUEUETABLE_G" 0 KB 0 rows . . exported "IX"."AQ$_ORDERS_QUEUETABLE_H" 0 KB 0 rows . . exported "IX"."AQ$_ORDERS_QUEUETABLE_I" 0 KB 0 rows . . exported "IX"."AQ$_ORDERS_QUEUETABLE_T" 0 KB 0 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_C" 0 KB 0 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_G" 0 KB 0 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_H" 0 KB 0 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_I" 0 KB 0 rows . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_T" 0 KB 0 rows . . exported "IX"."ORDERS_QUEUETABLE" 0 KB 0 rows . . exported "IX"."STREAMS_QUEUE_TABLE" 0 KB 0 rows . . exported "OLAPSYS"."CWM$ARGUMENT" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCOMPOSITESPEC" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCOMPSPECMEMBERSHIP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBEAGG" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBEAGGLEVEL" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBEAGGMEASURE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBECOMPPLAN" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBELOAD" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADAGGPLAN" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADFILTER" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADMEASURE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWCUBELOADPARMVALUE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWDIMLOAD" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWDIMLOADFILTER" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWDIMLOADPARMVALUE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWVIEWCOLS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AWVIEWS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AW_DIMENSIONMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$AW_MEASUREMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$CLASSIFICATIONVALUEPAIR" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$CUBE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$CUBEDIMENSIONUSE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$DIMENSION" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$DIMENSIONATTRIBUTE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$DIMHIERLVLMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$FACTDIMHIERMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$FACTDIMHIERTPLSDTL" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$FACTKEYDIMHIERLVLMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$FACTKEYDIMHIERMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$HIERARCHY" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$HIERCUSTOMSORT" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$HIERLEVELREL" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$LEVEL" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$LEVELATTRIBUTE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$LEVELATTRIBUTEMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MEASURE" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MEASURETABLEMAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_AWVIEWCOLS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_AWVIEWS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_CATALOGS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_CATALOG_ENTITY_USES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_CUBE_MEASURES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_CWM1_AGGOP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_CWM1_AGGORD" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_DIM_ATTRIBUTES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_DIM_HIERS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_DIM_HIER_LEVEL_USES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_DIM_LEVEL_ATTR_MAPS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_ENTITY_DESC_USES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_ENTITY_EXT_PARMS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_ENTITY_PARAMETERS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_FACTTBLFCTMAPS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_FACTTBLKEYMAPS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_HIERDIMS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_HIERDIM_KEYCOL_MAP" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_HIER_CUSTOM_SORT" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_JOIN_KEY_COL_USES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_LISTDIMS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRALL_OLAP2_AGG_USES" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRFACTTBLFCTMAPS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$MRFACTTBLKEYMAPS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$STOREDDIMLVLTPLS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$STOREDDIMLVLTPLSDTL" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$_AW_NEXT_PERM_CUST_MEAS" 0 KB 0 rows . . exported "OLAPSYS"."CWM2$_AW_PERM_CUST_MEAS_MAP" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AWS_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_ATTRIBUTES_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBES_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_AGG_LVL_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_AGG_MEAS_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_AGG_OP_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_AGG_SPECS_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_DIM_USES_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_CUBE_MEASURES_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_DIMENSIONS_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_DIM_LEVELS_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_HIER_LVL_ORD_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_MAP_ATTR_USE_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_MAP_DIM_USE_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_MAP_MEAS_USE_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_PHYS_OBJ_PROP_T" 0 KB 0 rows . . exported "OLAPSYS"."MRAC_OLAP2_AW_PHYS_OBJ_T" 0 KB 0 rows . . exported "OLAPSYS"."XML_LOAD_LOG" 0 KB 0 rows . . exported "OLAPSYS"."XML_LOAD_RECORDS" 0 KB 0 rows . . exported "OUTLN"."OL$" 0 KB 0 rows . . exported "OUTLN"."OL$HINTS" 0 KB 0 rows . . exported "OUTLN"."OL$NODES" 0 KB 0 rows . . exported "SCOTT"."BONUS" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows . . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows . . exported "SH"."MVIEW$_EXCEPTIONS" 0 KB 0 rows . . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows . . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows . . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows . . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows . . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows . . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_G" 0 KB 0 rows . . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_H" 0 KB 0 rows . . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I" 0 KB 0 rows . . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_T" 0 KB 0 rows . . exported "SYSMAN"."EM_IPW_INFO" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ADMIN_METRIC_THRESHOLDS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_AGENT_SEC_INFO" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ANNOTATION" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ARU_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BACKUP_CONFIGURATION" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_AVAIL_DEF" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_AVAIL_JOB" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_AVAIL_LOG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TARGET" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TARGET_LOCK" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TARGET_TXN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TXN_DEFN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TXN_HTTP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TXN_HTTP_PARAM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BCN_TXN_PING" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUTS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_FLAT_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_HISTORY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_SCHEDULE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_STATE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_TARGET_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BLACKOUT_WINDOWS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_ADVISORY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_ADVISORY_BUG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_ADV_HOME_PATCH" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_AVAILABLE_PATCH" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_FIX_APPLICABLE_COMP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_FIX_APPLIC_COMP_LIST" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_PATCH_FIXES_BUG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_BUG_PATCH_PLATFORM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_CHANGE_AGENT_URL" 0 KB 0 rows . . exported "SYSMAN"."MGMT_COLLECTION_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_COMP_RESULT_TO_JOB_MAP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_COMP_TARGET_DEF" 0 KB 0 rows . . exported "SYSMAN"."MGMT_CONTAINER_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_CREDENTIAL_TYPE_COL_VALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DBNET_TNS_ADMINS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DB_FEATUREUSAGE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DB_INVOBJS_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DB_LATEST_HDM_FINDINGS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DB_RECSEGMENTSETTINGS_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DB_RECUSERSETTINGS_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_COMPARISON_DELTAS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_COMP_DELTA_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_COMP_KEY_COLS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_COMP_PROPERTIES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_SUMMARY_ERRORS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_COMP_SUMMARIES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_ENTRY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_ENTRY_VALUES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_IDS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_ID_VALUES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DELTA_SAVED_COMPARISON" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DIROBJ_USERS_HOTLIST" 0 KB 0 rows . . exported "SYSMAN"."MGMT_DUPLICATE_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_DETAILS_1DAY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_DETAILS_1HOUR" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_JDBC" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_JDBC_1DAY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_JDBC_1HOUR" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SQL" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SQL_1DAY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SQL_1HOUR" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SQL_CONN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SQL_STMT" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SUMMARY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SUMMARY_1DAY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_E2E_SUMMARY_1HOUR" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_CSA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_CSA_COOKIES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_CSA_CUSTOM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_CSA_GENERAL_INFO" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_CSA_SNAPSHOT_INFO" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_HOST_CONFIGS_TO_DEL" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_HW" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_HW_CPU" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_HW_IOCARD" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_HW_NIC" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_LOADED_FILES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS_COMPONENT" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS_FILESYSTEM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS_PROPERTY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_COMP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ECM_PATCH_CACHE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_ENTERPRISE_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_FAILOVER_TABLE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_FLAT_TARGET_MEMBERSHIPS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HA_BACKUP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HA_CLS_INTR_CONN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HA_FILES_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HA_INIT_PARAMS_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HA_RAC_INTR_CONN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HC_IOCARD_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HC_NIC_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_HOST_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INDEX_SIZES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_COMPONENT_PATCH" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_CONTAINER_PROPERTY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_FILE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_PATCH" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_PATCHED_FILE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_PATCHED_FILE_COMP" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_PATCHSET" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_PATCH_FIXED_BUG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_INV_VERSIONED_PATCH" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_BLACKOUT_ASSOC" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_CALLBACKS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_CREDENTIALS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_EMD_STATUS_QUEUE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_EXEC_EVENT_PARAMS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_EXEC_LOCKS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_EXT_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_FLAT_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_LARGE_PARAMS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_LOCK_INFO" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_LOCK_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_OUTPUT" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_PARAMETER" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_PURGE_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_QUEUES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_STEP_COMMAND_LOG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_STEP_TARGETS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_JOB_TARGET" 0 KB 0 rows . . exported "SYSMAN"."MGMT_LONG_TEXT" 0 KB 0 rows . . exported "SYSMAN"."MGMT_MASTER_AGENT" 0 KB 0 rows . . exported "SYSMAN"."MGMT_METRIC_DEPENDENCY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_METRIC_DEPENDENCY_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFICATION_LOG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_DEVICES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_DEVICE_PARAMS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_DEV_SCHEDULES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_EMAIL_GATEWAY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_NOTIFYEES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_QTABLE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_REQUEUE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_NOTIFY_SCHEDULES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_OB_ADMIN_CLIENT_DB" 0 KB 0 rows . . exported "SYSMAN"."MGMT_OB_ADMIN_HOSTS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_OSM_DISK_GROUP_ECM" 0 KB 0 rows . . exported "SYSMAN"."MGMT_PLANPROBLEM_FACTORS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_POLICY_ERRORS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_POLICY_PARAMS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_POLICY_RULE_DEF_PARAMS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_PORTLET_PREFERENCE_STORE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_RCVCAT_CONFIG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_RCVCAT_REPOS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQLPROBLEM_FACTORS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_BIND_VARS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_EVALUATION" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_METRIC_HELPER" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_PLAN" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_REUSE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SQL_SUMMARY" 0 KB 0 rows . . exported "SYSMAN"."MGMT_SYSTEM_ERROR_LOG" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TABLE_SIZES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGETS_DELETE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_AGENT_ASSOC" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_ASSOC" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_ASSOC_INSTANCE" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_BASELINES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_BASELINES_DATA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_TARGET_MEMBERSHIPS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_CREDENTIALS_DATA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_OPERATIONS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_OPERATIONS_DATA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_OPERATIONS_DETAILS" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_PROPERTIES_DATA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_UPDATE_THRESHOLDS_DATA" 0 KB 0 rows . . exported "SYSMAN"."MGMT_USER_PREFERENCES" 0 KB 0 rows . . exported "SYSMAN"."MGMT_USER_TARGETS" 0 KB 0 rows . . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows . . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows . . exported "SYSTEM"."DEF$_TEMP$LOB" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$APPLY_MILESTONE" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$APPLY_PROGRESS":"P0" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$EVENTS" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$HISTORY" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$PARAMETERS" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$PLSQL" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SCN" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SKIP" 0 KB 0 rows . . exported "SYSTEM"."LOGSTDBY$SKIP_TRANSACTION" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_INDEX" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_PARTITION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_OBJECT_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows . . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows . . exported "TSMSYS"."SRS$" 0 KB 0 rows Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is: /u01/export/expFULL.dmp Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 18:20:26
Thus we see that the export completed successfully.
We can see what other options are available using the following help command.
bash-3.2$ expdp help=y
Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 10 July, 2012 19:17:06
Copyright (c) 2003, 2005, Oracle. All rights reserved.
The Data Pump export utility provides a mechanism for transferring data objects
between Oracle databases. The utility is invoked with the following command:
Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
You can control how Export runs by entering the 'expdp' command followed
by various parameters. To specify parameters, you use keywords:
Format: expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
USERID must be the first parameter on the command line.
Keyword Description (Default)
------------------------------------------------------------------------------
ATTACH Attach to existing job, e.g. ATTACH [=job name].
COMPRESSION Reduce size of dumpfile contents where valid
keyword values are: (METADATA_ONLY) and NONE.
CONTENT Specifies data to unload where the valid keywords are:
(ALL), DATA_ONLY, and METADATA_ONLY.
DIRECTORY Directory object to be used for dumpfiles and logfiles.
DUMPFILE List of destination dump files (expdat.dmp),
e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD Password key for creating encrypted column data.
ESTIMATE Calculate job estimates where the valid keywords are:
(BLOCKS) and STATISTICS.
ESTIMATE_ONLY Calculate job estimates without performing the export.
EXCLUDE Exclude specific object types, e.g. EXCLUDE=TABLE:EMP.
FILESIZE Specify the size of each dumpfile in units of bytes.
FLASHBACK_SCN SCN used to set session snapshot back to.
FLASHBACK_TIME Time used to get the SCN closest to the specified time.
FULL Export entire database (N).
HELP Display Help messages (N).
INCLUDE Include specific object types, e.g. INCLUDE=TABLE_DATA.
JOB_NAME Name of export job to create.
LOGFILE Log file name (export.log).
NETWORK_LINK Name of remote database link to the source system.
NOLOGFILE Do not write logfile (N).
PARALLEL Change the number of active workers for current job.
PARFILE Specify parameter file.
QUERY Predicate clause used to export a subset of a table.
SAMPLE Percentage of data to be exported;
SCHEMAS List of schemas to export (login schema).
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
TABLES Identifies a list of tables to export - one schema only.
TABLESPACES Identifies a list of tablespaces to export.
TRANSPORT_FULL_CHECK Verify storage segments of all tables (N).
TRANSPORT_TABLESPACES List of tablespaces from which metadata will be unloaded.
VERSION Version of objects to export where valid keywords are:
(COMPATIBLE), LATEST, or any valid database version.
The following commands are valid while in interactive mode.
Note: abbreviations are allowed
Command Description
------------------------------------------------------------------------------
ADD_FILE Add dumpfile to dumpfile set.
CONTINUE_CLIENT Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT Quit client session and leave job running.
FILESIZE Default filesize (bytes) for subsequent ADD_FILE commands.
HELP Summarize interactive commands.
KILL_JOB Detach and delete job.
PARALLEL Change the number of active workers for current job.
PARALLEL=<number of workers>.
START_JOB Start/resume current job.
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
STATUS[=interval]
STOP_JOB Orderly shutdown of job execution and exits the client.
STOP_JOB=IMMEDIATE performs an immediate shutdown of the
Data Pump job.
We will see what is the significance or use of each of the parameters mentioned above, run some tests and explore more on data pump in the coming posts.
So keep tuned for this space.
Categories: DBA
On reaching a milestone…
January 5, 2012
Leave a comment
Hello Readers,
First Wish you all a very happy and prosperous new year 2012…!
Its been ages since I had first started to write the blog. Today it reached the milestone of 100,000 hits. I thank every one who have visited my blog and wish to share more technical knowledge on Oracle database technology. Lately I have been off the scene on the writing front, but I am surely planning to come back with some write ups on interesting topics…
Thanks again for visiting.
Categories: Uncategorized
Deinstallation of Oracle11g R2 – not so straight forward.
September 7, 2010
10 comments
As the name of the post suggests the de-installation of Oracle11g R2 binaries is not so simple and straight forward as it used to be with the earlier releases of Oracle. Earlier you need to only invoke the OUI, select the ORACLE_HOME and say “remove”, it would remove and clean the binaries in that particular ORACLE_HOME. However with Oracle11g R2, it seems to be a bit different.
I tried de-installing the Oracle 11g R2 binaries from the Windows XP machine. As usual when I selected the ORACLE_HOME to be de-installed and clicked “Remove” button, a message box popped up asking me to execute the deinstall executable on the OS command prompt.
I then executed the deinstall executable as below:
C:\oracle\11.2.0\deinstall>deinstall
Checking for required files and bootstrapping ...
Please wait ...
14 File(s) copied
792 File(s) copied
1 file(s) copied.
1 file(s) copied.
Location of logs C:\Program Files\Oracle\Inventory\logs\
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration START
Checking for existence of the Oracle home location C:\oracle\11.2.0
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: C:\oracle
Checking for existence of central inventory location C:\Program Files\Oracle\Inventory
Install check configuration END
Checking Windows and .NET products configuration START
The following Windows and .NET products will be deconfigured from the Oracle home : asp.net,ode.net,odp.net,ntoledb,oramts,oo4o
Checking Windows and .NET products configuration END
Network Configuration check config START
Network de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\netdc_check4760274967572412600.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\databasedc_check6742172247021376588.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\emcadc_check.log
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : C:\Program Files\Oracle\Inventory\logs\\ocm_check820.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for de-install is: C:\oracle\11.2.0
Inventory Location where the Oracle home registered is: C:\Program Files\Oracle\Inventory
The following Windows and .NET products will be deconfigured from the Oracle home : asp.net,ode.net,odp.net,ntoledb,oramts,oo4o
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: 'C:\Program Files\Oracle\Inventory\logs\deinstall_deconfig2010-09-07_01-11-35-PM.out'
Any error messages from this session will be written to: 'C:\Program Files\Oracle\Inventory\logs\deinstall_deconfig2010-09-07_01-11-35-PM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\emcadc_clean.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\databasedc_clean8577526278596404055.log
Network Configuration clean config START
Network de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\netdc_clean7317355554868592236.log
De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.
De-configuring backup files...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : C:\Program Files\Oracle\Inventory\logs\\ocm_clean820.log
Oracle Configuration Manager clean END
Removing Windows and .NET products configuration START
Removing Windows and .NET products configuration END
Oracle Universal Installer clean START
Removing service 'OracleOraDb11g_home2ClrAgent' on the local node : Done
Oracle Universal Installer cleanup completed with errors.
Oracle Universal Installer clean END
Oracle install clean START
Oracle install clean END
Moved default properties file C:\Documents and Settings\akkivallip\Local Settings\Temp\OraDeinstall2010-09-07_13-10-03\response\deinstall_OraDb11g_home2.rsp as C:\Documents and Settings\akkivallip\Local Settings\Temp\OraDeinstall2010-09-07_13-10-03\response\deinstall_OraDb11g_home2.rsp3
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Removed asp.net configuration
Removed ode.net configuration
Removed odp.net configuration
Removed ntoledb configuration
Removed oramts configuration
Removed oo4o configuration
Successfully removed service 'OracleOraDb11g_home2ClrAgent' on the local node.
Oracle Universal Installer cleanup completed with errors.
Oracle install successfully cleaned up the temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
1 file(s) moved.
C:\oracle\11.2.0\deinstall>
Once the deinstall execution completed successfully, only then I was able to remove the ORACLE_HOME list in the OUI by clicking the “Remove” button.
Finally, the ORACLE_HOME is de-installed.
Oracle 10g Client ORACLE_HOME movement.
August 12, 2010
2 comments
Recently did a small test with the binaries. The oracle client had been installed in ‘/home/oracle/10.2.0client’, which was wrong as per the conventions that are being followed. As per the convention, the binaries had to be installed in ‘/app/oracle/10.2.0Client/’. Now there was a need to install the binaries in the intended path as it was installed in the home of oracle user, which did not have much space allocated to it (/home/oracle). The process to be followed was:
1. Uninstall the binaries on ‘/home/oracle/10.2.0Client’.
2. Install the binaries on ‘/appl/oracle/10.2.0Client’
This would have taken time to complete the task. Over and above we did not have console available to us. The installation was supposed to be done using the response file. So I thought of an alternative to copy the binaries to the desired location instead of installing the same using OUI.
First I copied all the binaries to the desired location maintaining the time bit information.
$ cp -Rp /home/oracle/10.2.0Client /appl/oracle/
Once the binaries are copied to the desired location, change the ORACLE_HOME in .profile file. Logout and login again for .profile changes to take the effect. If you try running sqlplus now from the new ORACLE_HOME, error will be thrown since the path internally referred by the binaries still point to /home/oracle/10.2.0Client. To update the same, do the relinking of binaries.
$ cd $ORACLE_HOME/bin $ relink all
After the relink completes successfully, try executing the sqlplus and this time you should be able to execute it without any issues.
Oracle binaries internally does not seem to refer the absolute path. Hence when the folder is copied to other location, it refers the path as ORACLE_HOME/*. Relinking the binaries after changing the ORACLE_HOME path in .profile file takes the new path into effect and works normally as it did priorly. If we see the relink file we will be able to see the usage of path, which is relative to ORACLE_HOME.
$ cat relink
.
.
#--------------------------------
# functions per script parameter
call_make () {
# parameters: $1 script parameter, $2 = make target
prm=$1
target=$2
case $prm in
oracle)
files="$ORACLE_HOME/rdbms/lib/ins_rdbms.mk" ;;
network)
files="$ORACLE_HOME/network/lib/ins_net_client.mk \
$ORACLE_HOME/network/lib/ins_net_server.mk \
$ORACLE_HOME/network/lib/ins_cman.mk \
$ORACLE_HOME/network/lib/ins_names.mk" ;;
client)
files="$ORACLE_HOME/network/lib/ins_net_client.mk \
$ORACLE_HOME/plsql/lib/ins_plsql.mk" ;;
client_sharedlib)
files="$ORACLE_HOME/network/lib/ins_net_client.mk" ;;
interMedia)
files="$ORACLE_HOME/ctx/lib/ins_ctx.mk" ;;
ctx)
files="$ORACLE_HOME/ctx/lib/ins_ctx.mk" ;;
utilities)
files="$ORACLE_HOME/rdbms/lib/ins_rdbms.mk" ;;
sqlplus)
files="$ORACLE_HOME/sqlplus/lib/ins_sqlplus.mk" ;;
oemagent)
files="$ORACLE_HOME/sysman/lib/ins_sysman.mk" ;;
ldap)
files="$ORACLE_HOME/ldap/lib/ins_ldap.mk" ;;
all)
files="`$FIND $ORACLE_HOME -follow -name 'ins_*.mk'`" ;;
esac
.
.
.
.
all () {
client_sharedlib
cleanup
precomp
cleanup
call_ldap_make
cleanup
call_make "utilities" "utilities"
cleanup
call_make $param "install"
cleanup
}
Categories: DBA
Case sensitive password in Oracle11g
August 3, 2010
Leave a comment
Today I was asked to setup a db_link between two of the databases. The version of the database on which the db_link had to be created was 9.2.0.8 and the version of the target database was 11.1.0.6. I first created the database link using standard syntax as given below:
SQL> create database link orcl11.db 2 connect to test identified by test123 3 using 'TESTDB'; Database link created.
Then I tried selecting the sysdate from the target database. To my surprise it failed with the error.
SQL> select sysdate from dual@orcl11.db;
SELECT * FROM dual@orcl11
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from ORCL11.DB
As per my information the username and password for the TESTDB database was correct. Then I tried connecting to the database using sqlplus on the server.
$ sqlplus test/test123@TESTDB ERROR: ORA-01017: invalid username/password; logon denied
However when the connection was made using the correct case for the password, it went through well.
$ sqlplus test/Test123@TESTDB SQL*Plus: Release 9.2.0.8.0 - Production on Tue Aug 3 16:37:15 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
I then recreated the database link using following statement.
SQL> drop database link orcl11.db; Database link dropped. SQL> create database link orcl11.db 2 connect to test identified by "Test123" 3 using 'TESTDB'; Database link created.
Now when I tested the link, it worked fine.
SQL> select sysdate from dual@orcl11.db; SYSDATE -------------------- 03-AUG-2010 16:41:41
Hence from Oracle 11g onwards all the database passwords are case sensitive and should be handled with care to avoid sudden surprises.
One can disable the password sensitivity by setting the initialization parameter SEC_CASE_SENSITIVE_LOGON to false. This parameter can be used to tackle the authentication issues being faced by the applications connecting to Oracle 11g databases. The default value for this parameter is true.
SQL> alter system set sec_case_sensitive_logon=false; System altered. SQL> conn test/Test123@testdb Connected. SQL> conn test/test123@testdb Connected.
Categories: General
Praveen Akkivalli.
I have been working with Oracle technologies for 11 years. Have worked as developer as well as DBA. So my development skills have always helped me in writing automation unix and PL/SQL scripts for my DBA tasks. The basic reason for me getting into Oracle technology is the fascination to know how it works internally. I still have to learn many things in this technology. That's why I am here with the blog.
Miracles of Oracle 
Recent Comments