The below command will not import the dump, but will just create a .sql file with the DDL statements
impdp system/**** directory=import_dir dumpfile=IMPORT.DMP sqlfile=getddl.sql
Advertisements
The below command will not import the dump, but will just create a .sql file with the DDL statements
impdp system/**** directory=import_dir dumpfile=IMPORT.DMP sqlfile=getddl.sql
Unix & Oracle stories
Remarks of the programmer
The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes
Learn from the mistakes of others - you can never live long enough to make them all yourself...
My thoughts on Oracle
DBA's online diary
SQL Server (TSQL) Programming, DB concepts, Tips & Tricks with >400 articles... comments welcome!!!
Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.
