impdp sqlfile parameter
KSGMar 24 2010 — edited Mar 25 2010Hi,
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