I want to run tool "expdp" which would export all schemas and objects in schemas, but takes no data from tables. 1. Is this the correct sample command for that:
expdp userid=system/a@local.live165 CONTENT=METADATA_ONLY FULL=Y DUMPFILE=exp_live_ddl.dmp LOGFILE=exp_live_ddl.log
I looked into file "exp_live_ddl.log" and it doesn't have any sql-statements, it only has such content:
;;;
Export: Release 10.2.0.1.0 - Production on Neljapäev, 11 November, 2010 12:12:08
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": userid=system/********@local.live165 CONTENT=METADATA_ONLY FULL=Y DUMPFILE=exp_live_ddl.dmp LOGFILE=exp_live_ddl.log
Processing object type DATABASE_EXPORT/TABLESPACE
...
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
D:\ORACLE2\PRODUCT\10.2.0\ADMIN\LIVE\DPDUMP\EXP_LIVE_DDL.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 12:14:01
Previous old tool "exp" produced export-log-file where i could see sql-statements, i could see what objects where created and with which sql-clause. 2. Is it possible with "expdp"-tool to produce similar log-file, which shows the sql-sentences inside?
I understand that "impdp" has parameter "sqlfile" that produces the file with sql-sentences that are executed during the import. But for exporting we seems not to have "sqlfile"-aparameter or other possiblity to see the sql-senteces as i udnerstand.
Edited by: CharlesRoos on 11.11.2010 12:32
Edited by: CharlesRoos on 11.11.2010 12:34