Fine-Grained Object

▣ 사용자 내에 있는 모든 객체 export ( 전체 )

[oracle@edrsr4p1 ~]$ expdp scott/tiger directory=dmpdir dumpfile=scott_emp30.dmp query=scott.emp:\"where deptno=30\"

   

Export: Release 10.2.0.1.0 - Production on Sunday, 16 August, 2009 21:41:13

   

Copyright (c) 2003, 2005, Oracle. All rights reserved.

   

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** directory=dmpdir dumpfile=scott_emp30.dmp query=scott.emp:"where deptno=30"

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 25.18 MB

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/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/COMMENT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "SCOTT"."TM" 3.818 MB 100000 rows

. . exported "SCOTT"."BIBLE" 2.692 MB 17761 rows

. . exported "SCOTT"."PT":"PT_P4" 2.435 MB 150001 rows

. . exported "SCOTT"."PT":"PT_P1" 1.615 MB 99999 rows

. . exported "SCOTT"."PT":"PT_P2" 1.625 MB 100000 rows

. . exported "SCOTT"."PT":"PT_P3" 1.625 MB 100000 rows

. . exported "SCOTT"."PT2":"PT2_P1"."PT2_P1_S1" 1.807 MB 100001 rows

. . exported "SCOTT"."DEPT" 5.656 KB 4 rows

. . exported "SCOTT"."EMP" 7.507 KB 6 rows

. . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows

. . exported "SCOTT"."BONUS" 0 KB 0 rows

. . exported "SCOTT"."COUNTRY" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P1"."PT2_P1_S2" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P1"."PT2_P1_S3" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P1"."PT2_P1_S4" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P2"."PT2_P2_S1" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P2"."PT2_P2_S2" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P2"."PT2_P2_S3" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P2"."PT2_P2_S4" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P3"."PT2_P3_S1" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P3"."PT2_P3_S2" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P3"."PT2_P3_S3" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P3"."PT2_P3_S4" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P4"."PT2_P4_S1" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P4"."PT2_P4_S2" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P4"."PT2_P4_S3" 0 KB 0 rows

. . exported "SCOTT"."PT2":"PT2_P4"."PT2_P4_S4" 0 KB 0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

/home/oracle/scott_emp30.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 21:41:37

   

▣ 유저 내에 있는 특정 객체만 export ( 일부 )

[oracle@edrsr4p1 ~]$ rm *.dmp

   

[oracle@edrsr4p1 ~]$ expdp scott/tiger directory=dmpdir dumpfile=scott_emp30.dmp query=scott.emp:\"where deptno=30\" tables=emp

   

Export: Release 10.2.0.1.0 - Production on Sunday, 16 August, 2009 21:42:05

   

Copyright (c) 2003, 2005, Oracle. All rights reserved.

   

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** directory=dmpdir dumpfile=scott_emp30.dmp query=scott.emp:"where deptno=30" tables=emp

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

. . exported "SCOTT"."EMP" 7.507 KB 6 rows

Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:

/home/oracle/scott_emp30.dmp

Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 21:42:15