oracle11g使用expdp/impdp备份数据
一、导出expdp工具使用方法:
1. 首先建立directory -- expdir(导入导出都要建立,对应的C:/exp文件夹如果不存在,需要手工建立) SQL> connect sys/123456 as sysdba SQL> create or replace directory expdir as 'C:/exp'; SQL> grant read,write on directory expdir to public; SQL> select * from dab_directories; SQL> commit; 2. 使用expdp命令导出某个用户的数据 expdp kliu_voi5/1234@orcl schemas=kliu_voi5 dumpfile=kliu_voi5.dmp directory=expdir 其中kliu_voi5/1234是用户名密码,orcl是oracle的sid。该命令完成后在c:exp下会有kilu_voi5.dmp文件
expdp kliu_voi5/1234@orcl schemas=kliu_voi5 dumpfile=kliu_voi5.dmp directory=expdir include=table:"like 'CT%'"
二、导入impdp工具使用方法: 1. 首先建立directory -- db_bak SQL> connect sys/123456 as sysdba SQL> create or replace directory db_bak as 'd:/db_bak'; SQL> grant read,write on directory db_bak to public; SQL> select * from dab_directories; SQL> commit; 2. 如果是在新的oracle数据库里,需用重建同样的用户 SQL> connect sys/123456 as sysdba SQL> create user kliu_voi5 identified by "1234"; SQL> grant dba to kliu_voi5; SQL> commit; 3. 使用impdp命令导入某个用户的数据impdp kliu_voi5/1234@orcl directory=db_bak dumpfile=kliu_voi5.dmp full=y
参考资料: http://blog.csdn.net/giianhui/article/details/7788550 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |