Shulou(Shulou.com)05/31 Report--

What is the difference between exp/imp and expdp/impdp? for this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

In the usual preparation of libraries and database migration, when you encounter a large database, it often takes several hours to use exp, which takes a lot of time. Oracle10g can later use expdp to export the database in much less time than exp takes, and the files are much smaller.

1. To use expdp, you must first create a directory in the database and give the corresponding user read,write permission.

The difference between SQL > create dexp and empdp irectory dmpdir as'/ u01Uniplex dmdir'

SQL > grant read,write on directory to test

two。 Common export methods

$expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=test

$expdp scott/tiger DUMPFILE=tmp_dump.dmp DIRECTORY=dmpdir TABLES= (tmp_test:p1,tmp_test:p2) JOB_NAME=tmp_dump LOGFILE=tmp_dump.log

$expdp scott/tiger DUMPFILE=full.dmp DIRECTORY=dmpdir FULL=Y JOB_NAME=full

$expdp scott/timer DUMPFILE=tmp_200703.dmp DIRECTORY=dmpdir TABLES=tmp QUERY=\ "where to_char\ (create_time,\ 'yyyy-mm-dd\')\

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.