Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

impdp sqlfile parameter

KSGMar 24 2010 — edited Mar 25 2010
Hi,

OS: HP-UX
Oracle10g

My production dba team sent me a sqlfile which contains 30K tables. They have used sqlfile= parameter to get DDL of the tables. I have to create the same DDL commands on my dev database.

My thinking is instead of generating the sqlfile ddl commands and recreating all the ddl in the dev enviornment.
why don't to use the below command to create table structures..

exp user/pwd file=abc.dmp rows=n schemas=aabb log=abc.log

Wouldn't the above given command creates all the table structures (DDL) ?

They why there is a need of sqlfile parameter to take all the DDLs and create manually?

Additionally pls brief me the importance of sqlfile parameter in expdp/impdp...


Thanks
KSG

Edited by: KSG on Mar 25, 2010 10:51 AM
This post has been answered by Anil Malkai on Mar 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2010
Added on Mar 24 2010
14 comments
19,124 views