oracle impdp metadata_only,expdp/impdp的CONTENT选项

expdp/impdp的CONTENT选项

CONTENT用于指定要导入/出的内容.默认值为ALL

CONTENT={ALL | DATA_ONLY | METADATA_ONLY}

当设置CONTENT为ALL 时,将导出对象定义及其所有数据.

为DATA_ONLY时,只导出对象数据,

为METADATA_ONLY时,只导出对象定义

1、创建DIRECTORY

create directory dir_dp as 'D:/oracle/dir_dp';

2、授权

Grant read,write on directory dir_dp to zftang;

--查看目录及权限

SELECT privilege, directory_name, DIRECTORY_PATH FROM user_tab_privs t, all_directories d

WHERE t.table_name(+) = d.directory_name ORDER BY 2, 1;

expdp user/pass DIRECTORY=dump DUMPFILE=data.dump CONTENT=METADATA_ONLY

impdp user/pass DIRECTORY=dump DUMPFILE=data.dump CONTENT=METADATA_ONLY

http://blog.sina.com.cn/s/blog_7930c09d010100lz.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14710393/viewspace-1454899/，如需转载，请注明出处，否则将追究法律责任。