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
http://www.bkjia.com/sjkqy/874340.html
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm
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
http://www.bkjia.com/sjkqy/874340.html
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14710393/viewspace-1454899/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14710393/viewspace-1454899/