注意:文件存储在服务器本地、目录的创建与授权请系统给权限
-----------------------------------expdp从11g Release
11.2.0.1.0 导出表GRID:
创建目录
CREATE or replace DIRECTORY DP_DIR AS 'E:\app\oradump';
---DROP DIRECTORY
DP_DIR
授权
GRANT READ,WRITE ON DIRECTORY DP_DIR TO ZJ;
or
grant read, write on directory DP_DIR to public;
执行文件expdp.par
expdp.par内容:
userid=zj/zj1234
directory=dp_dir
dumpfile=zhejiang_grid50.dmp
logfile=zhejiang_grid50.log
tables=zhejiang_grid50
reuse_dumpfiles=y
----------------------------------------------impdp导入12c
版本Oracle Database 12c Enterprise Edition Release
12.1.0.2.0
创建表空间
create tablespace ZJ datafile 'E:\ORADATA\ZJ.dbf' size
10240m;
创建用户
create user ZJ identified by "zj1234" default
tablespace ZJ;
授权
grant dba to
zj;----给执行、登陆权限就可以了
创建目录
CREATE or replace DIRECTORY DP_DIR AS
'E:\app\oradump';
---DROP DIRECTORY DP_DIR
授权目录
GRANT READ,WRITE ON DIRECTORY DP_DIR TO ZJ;
or grant read, write on directory DP_DIR to public;
SELECT * FROM DBA_DIRECTORIES;
impdp导入命令:
impdp ZJ/zj1234
DIRECTORY=DP_DIR DUMPFILE=grid.DMP
LOGFILE=grizj.log
select count(1)from grid;
commit;
删除用户及其表
drop user ZJ cascade;
删除表空间及其数据文件
drop tablespace ZJ including contents and
datafiles;