;;; Export: Release 11.2.0.4.0 - Production on Mon Jul 2 17:00:52 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": userid=system/******** DIRECTORY=storetw_dp_dir DUMPFILE=storet_owner_final_%u.cdmp logfile=storet_owner.log schemas=storet_owner filesize=5G parallel=2 flashback_time=systimestamp compression=all Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 12.62 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/SEQUENCE/SEQUENCE 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/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/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 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/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW . . exported "STORET_OWNER"."SAMPLE" 162.4 MB 21485963 rows . . exported "STORET_OWNER"."STATION" 14.29 MB 357844 rows . . exported "STORET_OWNER"."LEGACY_STORET_STATION_TYPE" 651.1 KB 186070 rows . . exported "STORET_OWNER"."EM_STATION_LOCATION" 28.96 MB 366945 rows . . exported "STORET_OWNER"."DESCRIPTIVE_PARAGRAPH_LINE" 22.29 MB 1221795 rows . . exported "STORET_OWNER"."RMI" 1.087 MB 38605 rows . . exported "STORET_OWNER"."ERROR_LOG" 4.448 MB 400814 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL5_ASSIGN2" 148.9 KB 27099 rows . . exported "STORET_OWNER"."STATION_ALIAS" 1.294 MB 210790 rows . . exported "STORET_OWNER"."STATION_LOCATION_POINT" 5.365 MB 375321 rows . . exported "STORET_OWNER"."EM_STATION_LOCATION_SDE" 24.43 MB 366945 rows . . exported "STORET_OWNER"."STATION_AQUIFER_ASSIGN2" 5.062 KB 0 rows . . exported "STORET_OWNER"."F1" 8.730 MB 366945 rows . . exported "STORET_OWNER"."MV_BLIND_COUNT" 4.703 KB 1 rows . . exported "STORET_OWNER"."EM_STN_LOC_IX_HL61$" 4.867 KB 0 rows . . exported "STORET_OWNER"."EM_STN_LOC_IX_HL6N1$" 6.061 MB 664857 rows . . exported "STORET_OWNER"."F4" 8.851 MB 366945 rows . . exported "STORET_OWNER"."S1" 5.310 MB 366945 rows . . exported "STORET_OWNER"."S4" 5.914 MB 366945 rows . . exported "STORET_OWNER"."STATION_COUNT" 1.578 MB 390909 rows . . exported "STORET_OWNER"."RF1_REACH" 582.2 KB 68187 rows . . exported "STORET_OWNER"."CHARACTERISTIC" 164.2 KB 9778 rows . . exported "STORET_OWNER"."PARAMETER" 241.2 KB 9083 rows . . exported "STORET_OWNER"."AQUIFER" 4.671 KB 0 rows . . exported "STORET_OWNER"."PARAMETER_COPY" 262.5 KB 9083 rows . . exported "STORET_OWNER"."SDE_LOGFILES" 5.289 KB 0 rows . . exported "STORET_OWNER"."SDE_LOGFILE_DATA" 4.687 KB 0 rows . . exported "STORET_OWNER"."INT_ORG" 76.76 KB 1972 rows . . exported "STORET_OWNER"."STATE_COUNTY" 40.45 KB 3347 rows . . exported "STORET_OWNER"."AGENCY" 39.03 KB 988 rows . . exported "STORET_OWNER"."CHILDLESS_SAMPLE" 8.703 KB 1815 rows . . exported "STORET_OWNER"."COMPOSITE_METHOD" 5.156 KB 4 rows . . exported "STORET_OWNER"."COMPOSITE_STATISTIC" 5.445 KB 18 rows . . exported "STORET_OWNER"."DECIMAL_POINT" 4.890 KB 11 rows . . exported "STORET_OWNER"."EFFLUENT_MONITORING_INTENT" 5.015 KB 10 rows . . exported "STORET_OWNER"."EFFLUENT_STATISTIC" 5.140 KB 14 rows . . exported "STORET_OWNER"."FIPS_HYDROLOGIC_UNIT" 28.72 KB 2285 rows . . exported "STORET_OWNER"."LAT_LONG_PRECISION" 4.898 KB 8 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL1" 5.828 KB 12 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL2A" 5.093 KB 2 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL2B" 5.171 KB 6 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL3" 5.148 KB 7 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL4" 4.906 KB 3 rows . . exported "STORET_OWNER"."LEGACY_STORET_LEVEL5" 6.882 KB 53 rows . . exported "STORET_OWNER"."LOCATION_POINT_TYPE" 4.820 KB 2 rows . . exported "STORET_OWNER"."MDXT_1639C$" 15.84 KB 512 rows . . exported "STORET_OWNER"."OMERNICH_LEVEL3_ECOREGION" 5.921 KB 76 rows . . exported "STORET_OWNER"."ORGANIZATION" 24.31 KB 304 rows . . exported "STORET_OWNER"."PARAMETER_GROUP" 5.25 KB 18 rows . . exported "STORET_OWNER"."PBCATCOL" 6.140 KB 4 rows . . exported "STORET_OWNER"."PBCATEDT" 5.531 KB 21 rows . . exported "STORET_OWNER"."PBCATFMT" 5.218 KB 20 rows . . exported "STORET_OWNER"."PBCATTBL" 6.281 KB 4 rows . . exported "STORET_OWNER"."PBCATVLD" 4.937 KB 0 rows . . exported "STORET_OWNER"."PLAN_TABLE" 6.117 KB 0 rows . . exported "STORET_OWNER"."PRIMARY_ACTIVITY_CATEGORY" 5 KB 11 rows . . exported "STORET_OWNER"."PRMRY_SCNDRY_ACTVTY_COMBO2" 5.359 KB 97 rows . . exported "STORET_OWNER"."REPORTING_UNITS" 5.171 KB 26 rows . . exported "STORET_OWNER"."SAMPLE_MEDIA_ANALYSIS_TYPE" 5.929 KB 28 rows . . exported "STORET_OWNER"."SDE_EXCEPTIONS" 4.859 KB 0 rows . . exported "STORET_OWNER"."SECONDARY_ACTIVITY_CATEGORY" 5.757 KB 48 rows . . exported "STORET_OWNER"."STORET_RESULT_REMARK" 6.031 KB 27 rows . . exported "STORET_OWNER"."STORET_X_STATION_TYPE" 5.648 KB 39 rows . . exported "STORET_OWNER"."TEMP_LOG" 16.15 KB 2834 rows . . exported "STORET_OWNER"."TOAD_PLAN_SQL" 4.859 KB 0 rows . . exported "STORET_OWNER"."TOAD_PLAN_TABLE" 9.554 KB 165 rows . . exported "STORET_OWNER"."TSMCDUS_TEMP" 5.078 KB 0 rows . . exported "STORET_OWNER"."UNUSED_PCODE" 4.585 KB 0 rows . . exported "STORET_OWNER"."RESULT" 973.4 MB 151009971 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/storet_owner_final_01.cdmp /public/data/storpubl/web/download/storetw/storet_owner_final_02.cdmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_03" successfully completed at Mon Jul 2 17:04:22 2018 elapsed 0 00:03:15