;;; Export: Release 12.1.0.2.0 - Production on Thu Mar 2 12:23:45 2023 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "ECOTEST"."SYS_EXPORT_SCHEMA_01": ecotest/********@ecotoxd directory=dp dumpfile=ecotest_03022023_v12.dmp logfile=ecotest_03022023_v12 schemas=ecotest version=12.1 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER 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/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/DB_LINK Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC 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/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/VIEW/VIEW 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/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW . . exported "ECOTEST"."ECOTOX_AQUIRE_MV" 1.549 GB 636780 rows . . exported "ECOTEST"."ECOTOX_TERRESTRIAL_EXCEL_MV" 1.323 GB 716052 rows . . exported "ECOTEST"."RESULTS" 1.147 GB 1141099 rows . . exported "ECOTEST"."ECOTOX_TERRESTRIAL_MV" 1.117 GB 504319 rows . . exported "ECOTEST"."ECOTOX_GROUP_SUMMARY3_MV" 511.5 MB 1203446 rows . . exported "ECOTEST"."TESTS" 506.0 MB 712726 rows . . exported "ECOTEST"."ZZ_P_C" 54.17 MB 477732 rows . . exported "ECOTEST"."ZZ_EPC_TABLE" 49.79 MB 477732 rows . . exported "ECOTEST"."DOSES" 45.32 MB 638811 rows . . exported "ECOTEST"."DOSE_CONCENTRATIONS" 37.82 MB 640496 rows . . exported "ECOTEST"."DOSE_RESPONSE_DETAILS" 35.91 MB 266420 rows . . exported "ECOTEST"."REFERENCES" 24.39 MB 126881 rows . . exported "ECOTEST"."DOSE_RESPONSES" 13.95 MB 116309 rows . . exported "ECOTEST"."TOX_DOSE_DISPLAY_MV" 9.105 MB 207673 rows . . exported "ECOTEST"."SPECIES" 7.447 MB 29325 rows . . exported "ECOTEST"."ECOTOX_TER_EXCEL_DOSE_MV" 7.461 MB 208066 rows . . exported "ECOTEST"."ECOTOX_TER_EXCEL_ORG_NUM_MV" 5.100 MB 207673 rows . . exported "ECOTEST"."CHEMICALS" 4.226 MB 17913 rows . . exported "ECOTEST"."AUTHOR_XREF" 3.514 MB 177751 rows . . exported "ECOTEST"."CHEMICAL_SYNONYMS" 2.004 MB 51052 rows . . exported "ECOTEST"."DOSE_RESPONSE_LINKS" 2.199 MB 115864 rows . . exported "ECOTEST"."MEASUREMENT_CODES" 1.310 MB 7203 rows . . exported "ECOTEST"."SPECIES_LIST_MATRIX" 873.7 KB 15302 rows . . exported "ECOTEST"."TEMP_SRS_CHEM_REFERENCES" 1002. KB 57193 rows . . exported "ECOTEST"."SPECIES_COMMON_SYNONYMS" 921.4 KB 41506 rows . . exported "ECOTEST"."TEMP_SRS_CHEM_SYNONYMS" 803.2 KB 13466 rows . . exported "ECOTEST"."TEMP_SRS_SPECIES_REFERENCES" 811.9 KB 40848 rows . . exported "ECOTEST"."SPECIES_LATIN_SYNONYMS" 617.0 KB 20525 rows . . exported "ECOTEST"."TEMP_SRS_SPECIES_SYNONYMS" 500.7 KB 6317 rows . . exported "ECOTEST"."SPECIES_LIST_XREF" 357.4 KB 30701 rows . . exported "ECOTEST"."EFFECT_MEASUREMENT_PAIRS" 209.7 KB 11977 rows . . exported "ECOTEST"."CONCENTRATION_UNIT_CODES" 133.5 KB 2523 rows . . exported "ECOTEST"."ECOTOX_CONFIG" 95.35 KB 28 rows . . exported "ECOTEST"."RESPONSE_SITE_CODES" 70.36 KB 606 rows . . exported "ECOTEST"."CHEMICAL_SEARCHES" 58.64 KB 814 rows . . exported "ECOTEST"."CONCENTRATION_CONVERSIONS" 43.94 KB 2540 rows . . exported "ECOTEST"."CHEMICAL_LIST_XREF" 41.87 KB 2900 rows . . exported "ECOTEST"."MEDIA_CHAR_UNIT_CODES" 30.12 KB 178 rows . . exported "ECOTEST"."ENDPOINT_CODES" 27.31 KB 270 rows . . exported "ECOTEST"."PREFERRED_CONC_TEST" 25.67 KB 98 rows . . exported "ECOTEST"."CHEMICAL_SEARCHES_CAS" 27.75 KB 1002 rows . . exported "ECOTEST"."CHEMICAL_FORMULATION_CODES" 17.05 KB 88 rows . . exported "ECOTEST"."CHEMICAL_GRADE_CODES" 17.03 KB 111 rows . . exported "ECOTEST"."LIFESTAGE_CODES" 17.02 KB 138 rows . . exported "ECOTEST"."EXPOSURE_TYPE_CODES" 17.20 KB 115 rows . . exported "ECOTEST"."APPLICATION_FREQUENCY_CODES" 16.58 KB 228 rows . . exported "ECOTEST"."TEST_METHOD_CODES" 15.39 KB 55 rows . . exported "ECOTEST"."DURATION_UNIT_CODES" 11.03 KB 171 rows . . exported "ECOTEST"."SAMPLE_SIZE_UNIT_CODES" 10.82 KB 134 rows . . exported "ECOTEST"."GEOGRAPHIC_CODES" 10.82 KB 248 rows . . exported "ECOTEST"."CHEMICAL_GROUP_TOP_MV" 9.992 KB 38 rows . . exported "ECOTEST"."TEST_TYPE_CODES" 9.468 KB 13 rows . . exported "ECOTEST"."MEDIA_TYPE_CODES" 9.382 KB 24 rows . . exported "ECOTEST"."ION_CODES" 9.273 KB 182 rows . . exported "ECOTEST"."EFFECTS_GROUP_TOP_MV" 8.515 KB 22 rows . . exported "ECOTEST"."SPECIES_GROUP_TOP_MV" 8.437 KB 18 rows . . exported "ECOTEST"."EFFECT_CODES" 8.445 KB 48 rows . . exported "ECOTEST"."TEST_LOCATION_CODES" 7.937 KB 6 rows . . exported "ECOTEST"."HABITAT_CODES" 7.523 KB 12 rows . . exported "ECOTEST"."RADIO_LABEL_CODES" 7.718 KB 90 rows . . exported "ECOTEST"."APPLICATION_TYPE_CODES" 7.320 KB 21 rows . . exported "ECOTEST"."CONCENTRATION_TYPE_CODES" 7.242 KB 10 rows . . exported "ECOTEST"."CONTROL_TYPE_CODES" 7.257 KB 16 rows . . exported "ECOTEST"."LENGTH_TYPE_CODES" 6.835 KB 9 rows . . exported "ECOTEST"."CHEMICAL_ANALYSIS_CODES" 6.773 KB 9 rows . . exported "ECOTEST"."EXPOSURE_TYPE_GROUP_CODES" 6.789 KB 10 rows . . exported "ECOTEST"."STATISTICAL_SIGNIFICANCE_CODES" 6.75 KB 8 rows . . exported "ECOTEST"."ORGANISM_SOURCE_CODES" 6.656 KB 12 rows . . exported "ECOTEST"."ORGANIC_MATTER_TYPE_CODES" 6.359 KB 17 rows . . exported "ECOTEST"."CHEMICAL_LISTS" 6.437 KB 41 rows . . exported "ECOTEST"."FIELD_STUDY_TYPE_CODES" 6.156 KB 10 rows . . exported "ECOTEST"."DOSE_STAT_METHOD_CODES" 6.132 KB 9 rows . . exported "ECOTEST"."WEIGHT_UNIT_CODES" 6.101 KB 8 rows . . exported "ECOTEST"."GENDER_CODES" 6.070 KB 6 rows . . exported "ECOTEST"."SUBSTRATE_CODES" 6.085 KB 11 rows . . exported "ECOTEST"."LENGTH_UNIT_CODES" 6.070 KB 5 rows . . exported "ECOTEST"."ENDPOINT_ASSIGNED_CODES" 6.078 KB 6 rows . . exported "ECOTEST"."TREND_CODES" 6.054 KB 7 rows . . exported "ECOTEST"."SEASON_CODES" 6.039 KB 7 rows . . exported "ECOTEST"."ORGANIC_CARBON_TYPE_CODES" 6.015 KB 4 rows . . exported "ECOTEST"."SPECIES_LISTS" 5.929 KB 18 rows . . exported "ECOTEST"."PTOX_CHEMICALS" 5.523 KB 43 rows . . exported "ECOTEST"."CHEMICAL_SEARCHES_TERMS" 0 KB 0 rows Master table "ECOTEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for ECOTEST.SYS_EXPORT_SCHEMA_01 is: /rdisk1/oracle/local/ecotoxd/dp/ecotest_03022023_v12.dmp Job "ECOTEST"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Mar 2 13:25:52 2023 elapsed 0 00:02:01