Hi all,
oracle 11g r2, rhel 5
we have an option to create a sql file from expdump. I used the below command
impdp system/***** directory=data_pump_dir dumpfile=scott.dmp logfile=scott.log sqlfile=scott.sql
The above command took all functions, view, procedures, triggers, tables , create ddl in a single file.
do we have an option to take all ddl script in a separate file for scott schema?
example: all grants for scrott schema in a separate file,
all create table ddl for scott schema in a separate file,
all view dll for scott schema in separate file,
all procedure for scott schema in separate file,
all function for scott schema in a separate file etc......
is this possible or any other available options apart from using toad and sql developer?
Regards,