/============================================================
数据泵技术
============================================================/
-1.创建目录
sys dba身份登录
create directory dump_dir as 'e:\backup';
--select * from dba_directories;
--drop directory dump_dir;
–2.授予用户操作dump_dir目录的权限
grant read,write on directory dump_dir to scott;
–3.创建测试用户user1并授权
create user user1 identified by user1;
grant connect,resource to user1;
grant read,write on directory dump_dir to user1;
–4.导入导出
/*--------表---------------*/
--导出scott用户下的表
C:\>expdp scott/tiger@orcl directory=dump_dir dumpfile=scotttab.dmp tables=emp,dept
--将dept,emp表导入user1中.
C:\>impdp system/tiger@orcl directory=dump_dir dumpfile=scotttab.dmp tables=dept,emp REMAP_SCHEMA=SCOTT:USER1
impdp system/tiger@orcl directory=dump_dir dumpfile=scotttab.dmp tables=dept,emp REMAP_SCHEMA=SCOTT:USER1
/*--------用户--------------*/
--导出scott用户模式
C:\>expdp scott/tiger@orcl directory=dump_dir dumpfile=scottschema.dmp schemas=scott
--导入scott用户模式
C:\>impdp scott/orcl@orcldb directory=dump_dir dumpfile=scottschema.dmp schemas=scott
--将scott中所有对象导入user1中.
C:\>impdp system/orcl@orcldb directory=dump_dir dumpfile=scottschema.dmp schemas=scott REMAP_SCHEMA=SCOTT:USER1
/*--------表空间--------------*/
--导出user01表空间
--提前创建一个users01表空间
C:\>expdp system/orcl@orcldb directory=dump_dir dumpfile=tablespaceusers.dmp tablespaces=users01
--导入user01表空间
C:\>impdp system/orcl@orcldb directory=dump_dir dumpfile=tablespaceusers.dmp tablespaces=users01
/*--------数据库--------------*/
--导出整个数据库
C:\>expdp system/orcl@orcldb directory=dump_dir dumpfile=full.dmp full=y
--导入整个数据库
C:\>impdp system/orcl@orcldb directory=dump_dir dumpfile=full.dmp full=y