Oracle数据泵技术导入导出

/============================================================
数据泵技术
============================================================/
-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