advertisements
_____________________________________________________________________________________________________________________
This is an
undocumented parameter for the data pump. The Matrics=y option will log the list
of objects exported or imported in each category and the time taken for each
category objects. All the details will be logged in the logfile. See an example
below.
$ expdp
dumpfile=tab_exp.dmp logfile=tab_exp.log schemas=sthomas metrics=Y
directory=exp_dir
Export:
Release 11.2.0.3.0 - Production on Thu Feb 13 14:13:37 2014
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Username:
/ as sysdba
Connected
to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting
"SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA dumpfile=tab_exp.dmp logfile=tab_exp.log
schemas=sthomas metrics=Y directory=exp_dir
Estimate
in progress using BLOCKS method...
Processing
object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total
estimation using BLOCKS method: 64.18 MB
Processing
object type SCHEMA_EXPORT/USER
Completed 1 USER objects in 0
seconds
Processing
object type SCHEMA_EXPORT/SYSTEM_GRANT
Completed 1 SYSTEM_GRANT objects
in 0 seconds
Processing
object type SCHEMA_EXPORT/ROLE_GRANT
Completed 1 ROLE_GRANT objects in 0
seconds
Processing
object type SCHEMA_EXPORT/DEFAULT_ROLE
Completed 1 DEFAULT_ROLE objects in 0
seconds
Processing
object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Completed 1 TABLESPACE_QUOTA objects in 2
seconds
Processing
object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Completed 1 PROCACT_SCHEMA objects in 7
seconds
Processing
object type SCHEMA_EXPORT/TABLE/TABLE
Completed 6 TABLE objects in 18 seconds
Processing
object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed 1 OBJECT_GRANT objects in 1
seconds
Processing
object type SCHEMA_EXPORT/TABLE/COMMENT
Completed 2 COMMENT objects in 1 seconds
Processing
object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Completed 1 PROCEDURE objects in 1 seconds
Processing
object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed 1 OBJECT_GRANT objects in 0
seconds
Processing
object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Completed 1 ALTER_PROCEDURE objects in 2
seconds
Processing
object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Completed 2 INDEX objects in 2 seconds
Processing
object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Completed 1 CONSTRAINT objects in 0
seconds
Processing
object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Completed 2 INDEX_STATISTICS objects in 4
seconds
Processing
object type SCHEMA_EXPORT/VIEW/VIEW
Completed 3 VIEW objects in 5 seconds
Processing
object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Completed 5 TABLE_STATISTICS
objects in 24 seconds
. . exported
"STHOMAS"."HINT_TEST" 52.38 MB 542392 rows
. . exported
"STHOMAS"."OBJ_LIST" 905.3 KB 9999 rows
. . exported
"STHOMAS"."DEPT" 6.351 KB 4 rows
. . exported
"STHOMAS"."MV_DEPT" 5.085 KB 4 rows
. . exported
"STHOMAS"."dept" 5.921 KB 3 rows
Master
table "SYS"."SYS_EXPORT_SCHEMA_01" successfully
loaded/unloaded
***********************************************************************
Dump file
set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u07/exp_dir/tab_exp.dmp
Job
"SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at
14:14:59
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment