;;; Export: Release 10.1.0.2.0 - Production on Sunday, 10 April, 2005 17:37 Copyright (c) 2003, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."SH_TABLESONLY": system/******** PARFILE=c:\rmancmd\SH_TablesOnly.dpectl Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 87.62 MB 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/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA . . exported "SH"."CUSTOMERS" 6.802 MB 50000 rows . . exported "SH"."FWEEK_PSCAT_SALES_MV" 5.689 MB 149325 rows . . exported "SH"."SALES":"SALES_Q1_1999" 2.790 MB 86217 rows . . exported "SH"."SALES":"SALES_Q1_2000" 3.375 MB 104544 rows . . exported "SH"."SALES":"SALES_Q2_1999" 2.824 MB 87298 rows . . exported "SH"."SALES":"SALES_Q2_2000" 3.375 MB 104652 rows . . exported "SH"."SALES":"SALES_Q3_2000" 2.945 MB 91260 rows . . exported "SH"."SALES":"SALES_Q4_1998" 2.701 MB 83415 rows . . exported "SH"."SALES":"SALES_Q4_1999" 3.231 MB 100110 rows . . exported "SH"."COSTS":"COSTS_Q1_2000" 1.752 MB 78468 rows Processing object type SCHEMA_EXPORT/TABLE/TABLE . . exported "SH"."COSTS":"COSTS_Q2_2000" 1.741 MB 78036 rows . . exported "SH"."PRODUCTS" 2.361 MB 10000 rows . . exported "SH"."SALES":"SALES_Q1_1998" 2.314 MB 71805 rows . . exported "SH"."SALES":"SALES_Q2_1998" 2.344 MB 72705 rows . . exported "SH"."SALES":"SALES_Q3_1998" 2.051 MB 63390 rows . . exported "SH"."SALES":"SALES_Q3_1999" 2.453 MB 76139 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX . . exported "SH"."SALES":"SALES_Q4_2000" 2.413 MB 74736 rows Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT . . exported "SH"."COSTS":"COSTS_Q1_1998" 1.283 MB 57879 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . exported "SH"."COSTS":"COSTS_Q1_1999" 1.504 MB 66940 rows Processing object type SCHEMA_EXPORT/TABLE/COMMENT . . exported "SH"."COSTS":"COSTS_Q2_1998" 1.299 MB 58450 rows Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY . . exported "SH"."COSTS":"COSTS_Q2_1999" 1.522 MB 67825 rows Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT . . exported "SH"."COSTS":"COSTS_Q3_1998" 1.179 MB 52570 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/SE_TBL_FBM_INDEX_INDEX/INDEX . . exported "SH"."COSTS":"COSTS_Q3_1999" 1.354 MB 60968 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/SE_TBL_FBM_IND_STATS/INDEX_STATISTICS . . exported "SH"."COSTS":"COSTS_Q3_2000" 1.571 MB 70424 rows . . exported "SH"."COSTS":"COSTS_Q4_1998" 1.476 MB 65803 rows . . exported "SH"."COSTS":"COSTS_Q4_1999" 1.681 MB 75591 rows . . exported "SH"."COSTS":"COSTS_Q4_2000" 1.220 MB 54812 rows . . exported "SH"."TIMES" 273.7 KB 1461 rows . . exported "SH"."CAL_MONTH_SALES_MV" 6.187 KB 35 rows . . exported "SH"."CHANNELS" 5.656 KB 5 rows . . exported "SH"."COUNTRIES" 6.554 KB 19 rows . . exported "SH"."PROMOTIONS" 41.71 KB 501 rows . . exported "SH"."MVIEW$_EXCEPTIONS" 0 KB 0 rows . . exported "SH"."MV_CAPABILITIES_TABLE" 0 KB 0 rows . . exported "SH"."PLAN_TABLE" 0 KB 0 rows . . exported "SH"."REWRITE_TABLE" 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 Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW Processing object type SCHEMA_EXPORT/DIMENSION Processing object type SCHEMA_EXPORT/SE_POST_SCHEMA_PROCOBJACT/PROCACT_SCHEMA Master table "SYSTEM"."SH_TABLESONLY" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SH_TABLESONLY is: C:\ORACLE\EXPORT_DIR\SHONLY_01.DMP C:\ORACLE\EXPORT_DIR\SHONLY_02.DMP Job "SYSTEM"."SH_TABLESONLY" successfully completed at 17:38