Usage of expdp

by Posted on

Export full database with compression option

expdp username/password directory=logical_directory dumpfile=dump_name_$date.dmp logfile=dump_name_$date.log compression=all

Export full database without compression option

expdp username/password directory=logical_directory dumpfile=dump_name_$date.dmp logfile=dump_name_$date.log

Export a specified table

expdp username/password directory=logical_directory dumpfile=dump_name_$date.dmp logfile=dump_name_$date.log tables=table_name

Donate

Published by byron

Leave a Reply