Suppose, you observe that export/import job is taking long time to complete and you want to diagnose the issue, then you need to add <LOGTIME=ALL> with <METRICS=y> options together to identify the elapsed time taken by each object with timestamp. This is required in case of you migrate the database from one operating system to another operating system and one DB version to different DB version and you observe that export/import operation is taking long time to complete. I n this situation, below two parameters are useful to diagnose the issue.
The <LOGTIME=ALL> option prints the timestamp for each export operation during expdp backup and <METRICS=y> option prints the additional info like number of objects with elapsed time.
You can compare last stuck operation timestamp and the previous one timestamp and calculate the elapsed time.
Example: 16-MAR-24 04:56:14.359: W-1 . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:18.605: W-1 . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows in 4 seconds using external_table 16-MAR-24 04:56:22.251: W-1 . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:22.390: W-1 . . exported "TEST"."DEPT" 6.531 KB 5 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.448: W-1 . . exported "TEST"."EMP" 6.531 KB 5 rows in 0 seconds using direct_path |
Here, you can see the object "SYSTEM.SCHEDULER_PROGRAM_ARGS" exported at 04:56:14.359 and the next object "WMSYS.WM$EXP_MAP" exported at 04:56:18.605 which means that the object "WMSYS.WM$EXP_MAP" took 4 seconds to complete. In this way, you can diagnose the issue at stuck object in export/import operation. Here, the export is not stuck , but you can troubleshoot the production issue like this way.
#Execute below command with <LOGTIME=ALL> and <METRICS=y> options together. C:\Windows\System32>expdp directory=DIR_TEST full=y dumpfile=FULL_DB.dmp logfile=FULL_DB.log LOGTIME=ALL METRICS=y Export: Release 19.0.0.0.0 - Production on Sat Mar 16 04:51:42 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 16-MAR-24 04:51:50.097: Starting "TEST"."SYS_EXPORT_FULL_01": test/******** directory=DIR_TEST full=y dumpfile=FULL_DB.dmp logfile=FULL_DB.log LOGTIME=ALL METRICS=y 16-MAR-24 04:51:50.930: W-1 Startup took 0 seconds 16-MAR-24 04:51:58.011: W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA 16-MAR-24 04:52:00.332: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA 16-MAR-24 04:52:02.851: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA 16-MAR-24 04:52:05.000: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA 16-MAR-24 04:52:05.445: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 16-MAR-24 04:52:05.568: W-1 Completed 8 INDEX_STATISTICS objects in 0 seconds 16-MAR-24 04:52:06.100: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS 16-MAR-24 04:52:06.151: W-1 Completed 9 TABLE_STATISTICS objects in 1 seconds 16-MAR-24 04:52:15.668: W-1 Processing object type DATABASE_EXPORT/STATISTICS/MARKER 16-MAR-24 04:52:15.861: W-1 Completed 1 MARKER objects in 9 seconds 16-MAR-24 04:52:15.910: W-1 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER 16-MAR-24 04:52:15.943: W-1 Completed 1 MARKER objects in 9 seconds 16-MAR-24 04:52:15.986: W-1 Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER 16-MAR-24 04:52:16.018: W-1 Completed 1 MARKER objects in 9 seconds 16-MAR-24 04:52:16.255: W-1 Processing object type DATABASE_EXPORT/TABLESPACE 16-MAR-24 04:52:16.309: W-1 Completed 3 TABLESPACE objects in 0 seconds 16-MAR-24 04:52:16.526: W-1 Processing object type DATABASE_EXPORT/PROFILE 16-MAR-24 04:52:16.560: W-1 Completed 1 PROFILE objects in 0 seconds 16-MAR-24 04:52:16.693: W-1 Processing object type DATABASE_EXPORT/SCHEMA/USER 16-MAR-24 04:52:16.726: W-1 Completed 5 USER objects in 0 seconds 16-MAR-24 04:52:16.893: W-1 Processing object type DATABASE_EXPORT/ROLE 16-MAR-24 04:52:16.941: W-1 Completed 1 ROLE objects in 0 seconds 16-MAR-24 04:52:16.993: W-1 Processing object type DATABASE_EXPORT/RADM_FPTM 16-MAR-24 04:52:17.027: W-1 Completed 1 RADM_FPTM objects in 0 seconds 16-MAR-24 04:52:17.408: W-1 Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT 16-MAR-24 04:52:17.443: W-1 Completed 7 PROC_SYSTEM_GRANT objects in 0 seconds 16-MAR-24 04:52:17.535: W-1 Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT 16-MAR-24 04:52:17.592: W-1 Completed 69 SYSTEM_GRANT objects in 0 seconds 16-MAR-24 04:52:17.658: W-1 Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT 16-MAR-24 04:52:17.718: W-1 Completed 32 ROLE_GRANT objects in 0 seconds 16-MAR-24 04:52:17.786: W-1 Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE 16-MAR-24 04:52:17.826: W-1 Completed 9 DEFAULT_ROLE objects in 0 seconds 16-MAR-24 04:52:17.894: W-1 Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT 16-MAR-24 04:52:17.943: W-1 Completed 6 ON_USER_GRANT objects in 0 seconds 16-MAR-24 04:52:18.093: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA 16-MAR-24 04:52:18.141: W-1 Completed 2 TABLESPACE_QUOTA objects in 0 seconds 16-MAR-24 04:52:18.209: W-1 Processing object type DATABASE_EXPORT/RESOURCE_COST 16-MAR-24 04:52:18.251: W-1 Completed 1 RESOURCE_COST objects in 0 seconds 16-MAR-24 04:52:18.476: W-1 Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK 16-MAR-24 04:52:18.509: W-1 Completed 1 DB_LINK objects in 0 seconds 16-MAR-24 04:52:18.577: W-1 Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK 16-MAR-24 04:52:18.625: W-1 Completed 1 TRUSTED_DB_LINK objects in 0 seconds 16-MAR-24 04:52:19.125: W-1 Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY 16-MAR-24 04:52:19.170: W-1 Completed 2 DIRECTORY objects in 0 seconds 16-MAR-24 04:52:20.608: W-1 Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT 16-MAR-24 04:52:20.642: W-1 Completed 4 OBJECT_GRANT objects in 1 seconds 16-MAR-24 04:52:33.988: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM 16-MAR-24 04:52:34.061: W-1 Completed 2 PROCACT_SYSTEM objects in 1 seconds 16-MAR-24 04:52:34.547: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ 16-MAR-24 04:52:34.597: W-1 Completed 23 PROCOBJ objects in 0 seconds 16-MAR-24 04:53:11.622: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM 16-MAR-24 04:53:12.237: W-1 Completed 3 PROCACT_SYSTEM objects in 1 seconds 16-MAR-24 04:53:12.584: W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA 16-MAR-24 04:53:12.623: W-1 Completed 10 PROCACT_SCHEMA objects in 0 seconds 16-MAR-24 04:53:22.967: W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE 16-MAR-24 04:53:23.037: W-1 Completed 1 TABLE objects in 7 seconds 16-MAR-24 04:53:23.079: W-1 Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER 16-MAR-24 04:53:23.113: W-1 Completed 1 MARKER objects in 1 seconds 16-MAR-24 04:53:51.301: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE 16-MAR-24 04:54:23.986: W-1 Completed 63 TABLE objects in 60 seconds 16-MAR-24 04:54:28.308: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE 16-MAR-24 04:54:57.420: W-1 Completed 18 TABLE objects in 33 seconds 16-MAR-24 04:54:57.453: W-1 Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER 16-MAR-24 04:54:57.492: W-1 Completed 1 MARKER objects in 0 seconds 16-MAR-24 04:55:00.141: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE 16-MAR-24 04:55:21.428: W-1 Completed 9 TABLE objects in 24 seconds 16-MAR-24 04:55:25.197: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT 16-MAR-24 04:55:33.618: W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW 16-MAR-24 04:55:33.651: W-1 Completed 1 VIEW objects in 4 seconds 16-MAR-24 04:55:40.236: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX 16-MAR-24 04:55:47.794: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT 16-MAR-24 04:55:47.834: W-1 Completed 8 CONSTRAINT objects in 7 seconds 16-MAR-24 04:55:54.739: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT 16-MAR-24 04:55:54.770: W-1 Completed 4 REF_CONSTRAINT objects in 0 seconds 16-MAR-24 04:55:59.652: W-1 Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER 16-MAR-24 04:55:59.681: W-1 Completed 1 MARKER objects in 0 seconds 16-MAR-24 04:56:09.393: W-1 Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE 16-MAR-24 04:56:09.424: W-1 Completed 2 AUDIT_POLICY_ENABLE objects in 0 seconds 16-MAR-24 04:56:09.889: W-1 Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER 16-MAR-24 04:56:09.921: W-1 Completed 1 MARKER objects in 0 seconds 16-MAR-24 04:56:10.413: W-1 . . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.117 KB 41 rows in 1 seconds using external_table 16-MAR-24 04:56:10.896: W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P181" 17.25 MB 10143 rows in 0 seconds using direct_path 16-MAR-24 04:56:10.998: W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P596" 77.67 KB 63 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.085: W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P450" 58.56 KB 18 rows in 1 seconds using direct_path 16-MAR-24 04:56:11.181: W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P641" 56.96 KB 15 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.251: W-1 . . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.314: W-1 . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.363: W-1 . . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.430: W-1 . . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.496: W-1 . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.546: W-1 . . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.596: W-1 . . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.657: W-1 . . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.713: W-1 . . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.763: W-1 . . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.830: W-1 . . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.880: W-1 . . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:11.948: W-1 . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.014: W-1 . . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows in 1 seconds using direct_path 16-MAR-24 04:56:12.064: W-1 . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.131: W-1 . . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.213: W-1 . . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 50.95 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.217: W-1 . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.217: W-1 . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.231: W-1 . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.231: W-1 . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.248: W-1 . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.248: W-1 . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.264: W-1 . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.264: W-1 . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.279: W-1 . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.281: W-1 . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.292: W-1 . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.296: W-1 . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.296: W-1 . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.313: W-1 . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.313: W-1 . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.324: W-1 . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.330: W-1 . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.340: W-1 . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.413: W-1 . . exported "SYS"."AUD$" 23.46 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.464: W-1 . . exported "SYS"."DAM_CLEANUP_EVENTS$" 7.187 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.513: W-1 . . exported "SYS"."DAM_CLEANUP_JOBS$" 7.171 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.523: W-1 . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.532: W-1 . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.539: W-1 . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.541: W-1 . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.551: W-1 . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.551: W-1 . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.564: W-1 . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.566: W-1 . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.566: W-1 . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.581: W-1 . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.581: W-1 . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.598: W-1 . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.598: W-1 . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.610: W-1 . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.613: W-1 . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.613: W-1 . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.630: W-1 . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.631: W-1 . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.642: W-1 . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.647: W-1 . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.647: W-1 . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.663: W-1 . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.663: W-1 . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.675: W-1 . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:12.681: W-1 . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:13.111: W-1 . . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows in 1 seconds using external_table 16-MAR-24 04:56:13.608: W-1 . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows in 0 seconds using external_table 16-MAR-24 04:56:13.624: W-1 . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:13.640: W-1 . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:13.656: W-1 . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:13.767: W-1 . . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.146: W-1 . . exported "SYS"."NACL$_HOST_EXP" 6.976 KB 2 rows in 1 seconds using external_table 16-MAR-24 04:56:14.158: W-1 . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.158: W-1 . . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.171: W-1 . . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.171: W-1 . . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.186: W-1 . . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.201: W-1 . . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.201: W-1 . . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.296: W-1 . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:14.359: W-1 . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:18.605: W-1 . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows in 4 seconds using external_table 16-MAR-24 04:56:22.251: W-1 . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows in 0 seconds using external_table 16-MAR-24 04:56:22.390: W-1 . . exported "TEST"."DEPT" 6.531 KB 5 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.448: W-1 . . exported "TEST"."EMP" 6.531 KB 5 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.453: W-1 . . exported "COMP"."COUNTRIES" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.462: W-1 . . exported "COMP"."DEPARTMENT" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.467: W-1 . . exported "COMP"."EMPLOYEE" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.473: W-1 . . exported "COMP"."JOBS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.476: W-1 . . exported "COMP"."JOB_HISTORY" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.476: W-1 . . exported "COMP"."LOCATIONS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:22.506: W-1 . . exported "COMP"."REGIONS" 0 KB 0 rows in 0 seconds using direct_path 16-MAR-24 04:56:23.314: W-1 Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 1 seconds 16-MAR-24 04:56:23.314: W-1 Completed 67 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 2 seconds 16-MAR-24 04:56:23.314: W-1 Completed 18 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 10 seconds 16-MAR-24 04:56:23.314: W-1 Completed 9 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA objects in 0 seconds 16-MAR-24 04:56:25.018: W-1 Master table "TEST"."SYS_EXPORT_FULL_01" successfully loaded/unloaded 16-MAR-24 04:56:25.080: ****************************************************************************** 16-MAR-24 04:56:25.080: Dump file set for TEST.SYS_EXPORT_FULL_01 is: 16-MAR-24 04:56:25.084: C:\BACKUP\FULL_DB.DMP 16-MAR-24 04:56:25.141: Job "TEST"."SYS_EXPORT_FULL_01" successfully completed at Sat Mar 16 04:56:25 2024 elapsed 0 00:04:38 |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !
Great
ReplyDelete