expdp/impdp 使用总结
expdp/impdp 使用总结<div class="bvMsg">1. 使用expdp要先在数据库中创建directory,并给相应的用户read,write权限.<span style="font-size: 12pt;" />
SQL>create directory dmpdir as '/u01/dmdir';
SQL>grant read,write on directory to test;
2. 最常用导出方法<span style="font-size: 12pt;" />
$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\'\)\<\'2007-04\'\"
常用一些参数说明: <span style="font-size: 12pt;" />
<div style="text-indent: 18pt; text-align: left;">
页:
[1]