expdp/impdp for TABLES - Oracle Database Script. -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' --- Par file for export of multiple tables cat parfile=tables.par dumpfile=tables.dmp logfile=tables.log directory=EXPDIR tables=PROD_DATA.EMPLOYEE, PROD_DATA.DEPT, DEV_DATA.STAGING -- Run expdp command expdp parfile=tables.par
-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' --- Par file for export of multiple tables cat parfile=tables.par dumpfile=tables.dmp logfile=tables.log directory=EXPDIR tables=PROD_DATA.EMPLOYEE, PROD_DATA.DEPT, DEV_DATA.STAGING -- Run expdp command expdp parfile=tables.par