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/s/blog_7930c09d010100lz.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub/14710393/viewspace-1454899/,如需转载,请注明出处,否则将追究法律责任。
更多推荐
oracle impdp metadata_only,expdp/impdp的CONTENT选项
发布评论