expdp with compression parameter - Oracle Database Script. -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Below is the parfile for full db export cat parfile=compressed.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR FULL=Y compression=ALL -- Run expdp command expdp parfile=compressed.par
-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Below is the parfile for full db export cat parfile=compressed.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR FULL=Y compression=ALL -- Run expdp command expdp parfile=compressed.par