expdp/impdp for schemas - Oracle Database Script. -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export of SCHEMAS(PROD_DATA,DEV_DATA) --cat parfile=schema.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR schemas=PROD_DATA, DEV_DATA -- Run expdp expdp parfile=schema.par For impdp also use the similar command.
-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export of SCHEMAS(PROD_DATA,DEV_DATA) --cat parfile=schema.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR schemas=PROD_DATA, DEV_DATA -- Run expdp expdp parfile=schema.par For impdp also use the similar command.