;;; Export: Release 11.2.0.4.0 - Production on Fri Jun 29 13:20:29 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_03": system/******** parfile=/usr/opt/oracle/local/backup/storetwcopy/parfiles/expdp_STORETW_owpubdw_Weekly.par Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 257.5 GB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC Processing object type SCHEMA_EXPORT/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/DB_LINK Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW Processing object type SCHEMA_EXPORT/JOB . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR0" 1.984 GB 16334133 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR5" 2.459 GB 21750090 rows . . exported "STORETW"."FA_BIOLOGICAL_RESULT" 4.041 GB 20547805 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR4" 4.097 GB 30580505 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR1" 2.874 GB 26551207 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR2" 3.458 GB 25894571 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR3" 1.884 GB 15867683 rows . . exported "STORETW"."FA_REGULAR_RESULT":"YEAR6" 1.951 GB 15496017 rows . . exported "STORETW"."STATION_CHAR" 1.043 GB 16247864 rows . . exported "STORETW"."FA_HABITAT_RESULT" 487.7 MB 7141143 rows . . exported "STORETW"."REGULAR_RESULT_PROJECT" 688.2 MB 292568848 rows . . exported "STORETW"."STATION_CHAR_MEDIUM" 765.2 MB 18178139 rows . . exported "STORETW"."WS_STATION_SUMMARY" 561.4 MB 9693638 rows . . exported "STORETW"."DW_DATA_REQUESTS" 164.7 MB 105082 rows . . exported "STORETW"."WS_STATION_DATA" 501.0 MB 9643260 rows . . exported "STORETW"."STATION_CHAR_YEAR" 692.3 MB 33193803 rows . . exported "STORETW"."WS_PROJECT_STATION_CHAR" 326.8 MB 10872918 rows . . exported "STORETW"."FA_ACTIVITY_METRIC" 214.6 MB 2416777 rows . . exported "STORETW"."WS_ORG_ACTIVITY" 132.6 MB 22390957 rows . . exported "STORETW"."WS_ORG_ACTIVITY_PROJECT" 89.82 MB 22617301 rows . . exported "STORETW"."WS_PROJECT_STATION_CHAR_TEMP" 140.2 MB 11081782 rows . . exported "STORETW"."STATION_CHAR_PROJECT" 534.2 MB 24018887 rows . . exported "STORETW"."BIOLOGICAL_RESULT_PROJECT" 56.21 MB 23655737 rows . . exported "STORETW"."FA_STATION" 95.22 MB 861912 rows . . exported "STORETW"."HABITAT_RESULT_PROJECT" 42.58 MB 16293452 rows . . exported "STORETW"."DI_GEO_COUNTY" 77.64 MB 3443 rows . . exported "STORETW"."ACTIVITY_GROUP_DETAIL" 26.57 MB 4211717 rows . . exported "STORETW"."DI_ECO_REGION" 50.21 MB 987 rows . . exported "STORETW"."FA_BIO_HABITAT_INDEX" 16.40 MB 564795 rows . . exported "STORETW"."STATION_YEAR" 28.43 MB 1601901 rows . . exported "STORETW"."DI_DB_CAT" 13.03 MB 2287 rows . . exported "STORETW"."METRIC_RESULT_PROJECT" 5.959 MB 3069779 rows . . exported "STORETW"."STG_FA_REGULAR_RESULT" 39.33 MB 379804 rows . . exported "STORETW"."MD_LAB_SAMPLE_PREP_PROCEDURE" 96.72 KB 2026 rows . . exported "STORETW"."WS_HUC_ORG_CHAR_SUMMARY" 14.64 MB 739630 rows . . exported "STORETW"."DI_CHARACTERISTIC" 4.863 MB 100466 rows . . exported "STORETW"."STG_DELETE_REF_BASELINE" 3.120 MB 1974471 rows . . exported "STORETW"."WS_DATA_REQUESTS" 69.85 MB 559263 rows . . exported "STORETW"."WS_HUC_CHAR_SUMMARY" 10.63 MB 573158 rows . . exported "STORETW"."DI_ORG" 77.12 KB 1356 rows . . exported "STORETW"."DI_GEO_STATE" 9.185 MB 114 rows . . exported "STORETW"."STATION_PROJECT" 10.17 MB 1006844 rows . . exported "STORETW"."STG_FA_REGULAR_HAB_RESULT" 22.15 MB 379804 rows . . exported "STORETW"."STATE_ORG_CHAR_YEAR" 9.807 MB 1040167 rows . . exported "STORETW"."FA_ACTIVITY_GROUP" 4.218 MB 285856 rows . . exported "STORETW"."STATE_CHAR_YEAR" 5.535 MB 740489 rows . . exported "STORETW"."LU_EXTERNAL_REF_SCHEME" 85.10 KB 3607 rows . . exported "STORETW"."DI_PROJECT" 5.729 MB 44572 rows . . exported "STORETW"."TEMP_DUPS_PROJNPS_HAS" 11.01 MB 62391 rows . . exported "STORETW"."BATCH_HUC_UPDATE_TEMP" 3.066 MB 554670 rows . . exported "STORETW"."TEMP_NPS_XMLSUBMIT1" 5.625 MB 30898 rows . . exported "STORETW"."TEMP_NPS_XMLSUBMIT2" 5.827 MB 30898 rows . . exported "STORETW"."TEMP_NPS_XMLSUBMIT3" 5.647 MB 30898 rows . . exported "STORETW"."LU_QA_AGENCY" 8.203 KB 229 rows . . exported "STORETW"."APP_COLUMN_NAME" 15.74 KB 298 rows . . exported "STORETW"."LU_CHARTYPE" 5.804 KB 21 rows . . exported "STORETW"."LU_CHAR_ALIAS" 2.054 MB 216176 rows . . exported "STORETW"."LU_ESTRY_PRIMARY" 7.328 KB 265 rows . . exported "STORETW"."LU_ESTRY_SECONDARY" 6.101 KB 124 rows . . exported "STORETW"."LU_MAD_HDATUM" 5.296 KB 17 rows . . exported "STORETW"."LU_MAD_VDATUM" 5.117 KB 6 rows . . exported "STORETW"."MD_ANALYTICAL_PROC" 1.000 MB 20650 rows . . exported "STORETW"."MD_CITATION" 146.8 KB 1871 rows . . exported "STORETW"."MD_COOP" 13.67 KB 286 rows . . exported "STORETW"."MD_COOP_ADDRESS" 8.179 KB 49 rows . . exported "STORETW"."MD_COOP_EADDRESS" 7.539 KB 84 rows . . exported "STORETW"."MD_LAB_ADDRESS" 21.06 KB 361 rows . . exported "STORETW"."MD_LAB" 81.96 KB 5434 rows . . exported "STORETW"."MD_LAB_EADDRESS" 16.39 KB 483 rows . . exported "STORETW"."MD_ORG_ADDRESS" 75.87 KB 1544 rows . . exported "STORETW"."MD_ORG_EADDRESS" 95.69 KB 3867 rows . . exported "STORETW"."MD_SAMPLE_GEAR" 30.35 KB 1772 rows . . exported "STORETW"."MD_SAMPLE_PRESRV" 74.19 KB 1146 rows . . exported "STORETW"."FA_REGULAR_RESULT":"ARCH" 11.23 GB 71088184 rows . . exported "STORETW"."MD_SAMPLE_PROC" 552.2 KB 26346 rows . . exported "STORETW"."MT_ATTRIBUTE_MAP" 7.257 KB 64 rows . . exported "STORETW"."SEQ_GEN" 6.476 KB 46 rows . . exported "STORETW"."MV_REGULAR_RESULT_CHAR_COUNTY" 2.214 MB 520683 rows . . exported "STORETW"."LU_UNIT_CONVERSION" 13.62 KB 392 rows . . exported "STORETW"."MV_REGULAR_RESULT_PROJECT_CHAR" 1.938 MB 392157 rows . . exported "STORETW"."DI_DATE" 584.4 KB 55152 rows . . exported "STORETW"."TEMP_XMLSUBMIT3_STG_FAREGHAB" 4.297 MB 30898 rows . . exported "STORETW"."WS_HUC_ORG_SUMMARY" 178.7 KB 8567 rows . . exported "STORETW"."CHARACTERISTIC_CHARTYPE" 185.2 KB 101642 rows . . exported "STORETW"."LU_STATION_ALIAS" 693.9 KB 68093 rows . . exported "STORETW"."ETL_EXECUTION_LOG" 1.260 MB 90165 rows . . exported "STORETW"."MT_CHAR_CHARTYPE" 17.76 KB 1513 rows . . exported "STORETW"."TRIBAL_STATION_YEAR" 818.4 KB 49694 rows . . exported "STORETW"."STG_ACTIVITY_PROJECT" 93.41 KB 55526 rows . . exported "STORETW"."TRIBAL_STATE_ORG_CHAR_YEAR" 806.7 KB 76874 rows . . exported "STORETW"."ACTIVITY_METRIC_INDEX" 266.2 KB 91266 rows . . exported "STORETW"."DI_BIOPART" 6.046 KB 101 rows . . exported "STORETW"."STG_DELETE_REF" 50.84 KB 58341 rows . . exported "STORETW"."TMP_STATION_DATA_ISSUES_BAK" 252.4 KB 7068 rows . . exported "STORETW"."FRR_FA_STATION" 161.2 KB 829 rows . . exported "STORETW"."DI_SUBJECT_TAXON" 327.3 KB 20059 rows . . exported "STORETW"."ETL_EXECUTION_ERROR" 5.804 KB 6 rows . . exported "STORETW"."MV_REGULAR_RESULT_ALL" 4.703 KB 1 rows . . exported "STORETW"."STG_LU_STATION_ALIAS" 394.0 KB 49510 rows . . exported "STORETW"."DI_STATN_TYPES" 7.078 KB 104 rows . . exported "STORETW"."MV_REGULAR_RESULT_CHAR_STATE" 151.7 KB 35226 rows . . exported "STORETW"."POST_ETL_EXECUTION_METRIC" 278.9 KB 13093 rows . . exported "STORETW"."STG_TAXON" 334.3 KB 12660 rows . . exported "STORETW"."MV_REGULAR_RESULT_CHAR" 20.33 KB 3489 rows . . exported "STORETW"."TOAD_PLAN_TABLE" 72.39 KB 835 rows . . exported "STORETW"."DI_ACTIVITY_MEDIUM" 5.046 KB 9 rows . . exported "STORETW"."TRIBAL_STATE_CHAR_YEAR" 592.6 KB 56612 rows . . exported "STORETW"."MV_REGULAR_RESULT_COUNTY" 20.50 KB 3177 rows . . exported "STORETW"."DI_ORG_TYPES" 5.195 KB 14 rows . . exported "STORETW"."LU_CHAR_ALIAS_TYPE" 5.289 KB 16 rows . . exported "STORETW"."MV_REGULAR_RESULT_STATE" 5.445 KB 63 rows . . exported "STORETW"."LU_INDEXTYPE" 112.3 KB 14769 rows . . exported "STORETW"."LU_ORGTYPE" 7.937 KB 1545 rows . . exported "STORETW"."POST_ETL_EXECUTION_STATUS" 6.148 KB 32 rows . . exported "STORETW"."LU_MAD_HMETHOD" 5.843 KB 40 rows . . exported "STORETW"."DI_ACTIVITY_MATRIX" 7.187 KB 109 rows . . exported "STORETW"."POST_ETL_RESULT_SYNC" 6.960 KB 68 rows . . exported "STORETW"."DI_METHOD" 195.1 KB 13421 rows . . exported "STORETW"."STATE_ORG_YEAR" 180.9 KB 16957 rows . . exported "STORETW"."POST_ETL_RESULT_SYNC_CONTROL" 4.945 KB 5 rows . . exported "STORETW"."FRR_DI_PROJECT" 81.55 KB 43 rows . . exported "STORETW"."LU_MAD_VMETHOD" 5.468 KB 17 rows . . exported "STORETW"."STATE_YEAR" 38.32 KB 3107 rows . . exported "STORETW"."MV_REGULAR_RESULT_PROJECT" 93.38 KB 20637 rows . . exported "STORETW"."STG_ACTIVITY_GROUP" 6.289 KB 16 rows . . exported "STORETW"."STG_ACTIVITY_GROUP_DETAIL" 14.21 KB 2746 rows . . exported "STORETW"."LU_METRICTYPE" 81.33 KB 3817 rows . . exported "STORETW"."STG_DI_ORG" 6.664 KB 23 rows . . exported "STORETW"."STG_FA_STATION" 137.9 KB 2430 rows . . exported "STORETW"."STG_DI_PROJECT" 18.92 KB 275 rows . . exported "STORETW"."TMP_FK_CHAR_FIX" 35.48 KB 16635 rows . . exported "STORETW"."DI_ACTIVITY_INTENT" 5.078 KB 9 rows . . exported "STORETW"."STG_LU_QA_AGENCY" 4.820 KB 5 rows . . exported "STORETW"."DI_COMMUNITY_SAMPLED" 5.757 KB 16 rows . . exported "STORETW"."STG_MD_ANALYTICAL_PROC" 9.664 KB 131 rows . . exported "STORETW"."STG_MD_LAB" 5.179 KB 17 rows . . exported "STORETW"."DI_GROUP_TYPE" 4.929 KB 4 rows . . exported "STORETW"."STG_MD_LAB_SAMPLE_PREP_PROC" 5.867 KB 28 rows . . exported "STORETW"."MT_WH_CONFIG" 7.078 KB 36 rows . . exported "STORETW"."STG_MD_ORG_ADDRESS" 5.929 KB 10 rows . . exported "STORETW"."STG_DI_CHARACTERISTIC" 76.17 KB 4024 rows . . exported "STORETW"."STG_MD_ORG_EADDRESS" 5.562 KB 16 rows . . exported "STORETW"."STG_STATION_PROJECT_ALL" 22.18 KB 14479 rows . . exported "STORETW"."STG_MD_ORG_EADDRESS_PHONE" 5.414 KB 15 rows . . exported "STORETW"."DI_EPA_REGION" 5.242 KB 11 rows . . exported "STORETW"."STG_MD_SAMPLE_GEAR" 5.460 KB 33 rows . . exported "STORETW"."ETL_EXECUTION_STATUS" 6.562 KB 43 rows . . exported "STORETW"."STG_MD_SAMPLE_PROC" 7.703 KB 94 rows . . exported "STORETW"."LU_CHARGRPTYPE" 5.546 KB 19 rows . . exported "STORETW"."TMP_FIX_WQX_TXRNK_UID" 8.039 KB 145 rows . . exported "STORETW"."LU_ORGSTATE" 5.789 KB 337 rows . . exported "STORETW"."TMP_MLOC_DUPS" 7.062 KB 352 rows . . exported "STORETW"."LU_WS_SERVICE" 4.953 KB 3 rows . . exported "STORETW"."TRANSACTION_BASELINE" 49.14 KB 1671 rows . . exported "STORETW"."MDXT_1EA3D$" 44.07 KB 512 rows . . exported "STORETW"."TRIBAL_STATE_ORG_YEAR" 34.69 KB 2730 rows . . exported "STORETW"."TRIBAL_STATE_YEAR" 12.93 KB 737 rows . . exported "STORETW"."MT_PROD_OBJECTS" 11.00 KB 654 rows . . exported "STORETW"."WS_WEB_METHOD" 5.703 KB 14 rows . . exported "STORETW"."WS_WEB_METHOD_INPUT_PARAM" 5.875 KB 26 rows . . exported "STORETW"."MD_PROGRAM" 0 KB 0 rows . . exported "STORETW"."MT_OBJECT_DDL_WQX_ETL" 0 KB 0 rows . . exported "STORETW"."PLAN_TABLE" 0 KB 0 rows . . exported "STORETW"."STG_ACTIVITY_METRIC_INDEX" 0 KB 0 rows . . exported "STORETW"."STG_DI_ACTIVITY_INTENT" 0 KB 0 rows . . exported "STORETW"."STG_DI_ACTIVITY_MATRIX" 0 KB 0 rows . . exported "STORETW"."STG_DI_ACTIVITY_MEDIUM" 0 KB 0 rows . . exported "STORETW"."STG_DI_BIOPART" 0 KB 0 rows . . exported "STORETW"."STG_DI_COMMUNITY_SAMPLED" 0 KB 0 rows . . exported "STORETW"."STG_DI_GEO_COUNTY" 0 KB 0 rows . . exported "STORETW"."STG_DI_GEO_STATE" 0 KB 0 rows . . exported "STORETW"."STG_DI_STATN_TYPES" 0 KB 0 rows . . exported "STORETW"."STG_FA_ACTIVITY_METRIC" 0 KB 0 rows . . exported "STORETW"."STG_FA_ACTIVITY_METRIC_SRC" 0 KB 0 rows . . exported "STORETW"."STG_FA_BIO_HABITAT_IDX" 0 KB 0 rows . . exported "STORETW"."STG_FA_BIO_RESULT_SRC" 0 KB 0 rows . . exported "STORETW"."STG_FA_BIO_RESULT_TRG" 0 KB 0 rows . . exported "STORETW"."STG_FA_BLOB" 0 KB 0 rows . . exported "STORETW"."STG_FA_HABITAT_RESULT" 0 KB 0 rows . . exported "STORETW"."STG_LU_INDEXTYPE" 0 KB 0 rows . . exported "STORETW"."STG_LU_MAD_HDATUM" 0 KB 0 rows . . exported "STORETW"."STG_LU_MAD_HMETHOD" 0 KB 0 rows . . exported "STORETW"."STG_LU_MAD_VDATUM" 0 KB 0 rows . . exported "STORETW"."STG_LU_MAD_VMETHOD" 0 KB 0 rows . . exported "STORETW"."STG_LU_METRICTYPE" 0 KB 0 rows . . exported "STORETW"."STG_LU_UNIT_CONVERSION" 0 KB 0 rows . . exported "STORETW"."STG_MD_CITATION" 0 KB 0 rows . . exported "STORETW"."STG_MD_SAMPLE_PRESRV" 0 KB 0 rows . . exported "STORETW"."STG_STATION_PROJECT" 0 KB 0 rows . . exported "STORETW"."FA_BLOB" 17.10 GB 80583 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_03" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_03 is: /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_01.cdmp /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_02.cdmp /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_03.cdmp /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_04.cdmp /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_05.cdmp /public/data/storpubl/web/download/storetw/owpubdw_vmwaters1_storetw_Weekly_06.cdmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_03" successfully completed at Fri Jun 29 14:37:12 2018 elapsed 0 01:16:35