基本导出方法：



CREATE OR REPLACE DIRECTORY test_dir(directory别名) AS /u01/app/oracle/oradata/ (此处为硬盘上路径)

GRANT READ, WRITE ON DIRECTORY test_dir(directory别名) TO scott(指定用户名)/public(所有用户)

expdp scott/scott@orcl directory=test_ DUMPFILE=xx.dmp schemas=scott(用户名) logfile=expdpScott.log version=10.2.0.1.0(导入数据版本号,同版本内可选参数)-The basic method of export:

CREATE OR REPLACE DIRECTORY test_ (directory AS /u01/app/oracle/oradata/ (alias) here for the hard disk path)

GRANT READ, WRITE ON DIRECTORY test_ (directory TO Scott (alias) specifies the user name (/public) for all users)

Expdp scott/scott@orcl directory=test_ DUMPFILE=xx.dmp schemas=scott logfile=expdpScott.log version=10.2.0.1.0 (user name) (import data version, with version optional)