DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

Data Pump and export Parameters-Metadata Only



Data Pump and export Parameters-Metadata Only


Data Pump Parameters-Metadata Only

expdp scott/tiger tables=EMP directory=TEST_DIR dumpfile=q1.dmp content=metadata_only


[oracle@oracle11g dump]$ expdp scott/tiger tables=EMP directory=TEST_DIR dumpfile=q1.dmp content=metadata_only

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 11:16:19 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** tables=EMP directory=TEST_DIR dumpfile=q1.dmp content=metadata_only
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
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  /u01/dump/q1.dmp

Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 11:16:40




Export Parameters-Metadata Only

exp scott/tiger tables=EMP file=/u01/rows.dmp log=/u01/rows.log rows=n


[oracle@oracle11g dump]$ exp scott/tiger tables=EMP file=/u01/rows.dmp log=/u01/rows.log rows=n

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 11:16:33 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
Note: table data (rows) will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                            EMP

Export terminated successfully without warnings.





No comments: