车辆资产管理系统的数据库还原impdp的相关脚本

2017-02-06 14:20:23 访问(1644) 赞(0) 踩(0)


-- sys(dba) 登录的状态下 --
create temporary tablespace v9db_temp 
tempfile 'v9db_temp.dbf' 
size 32m 
autoextend on 
next 32m maxsize 100m 
extent management local; 

create tablespace v9db_data 
logging 
datafile 'v9db_data01.dbf' 
size 200m 
autoextend on 
next 32m maxsize 300m 
extent management local; 


create user v9db identified by v9db 
default tablespace v9db_data 
temporary tablespace v9db_temp; 


grant connect,resource to v9db; 

grant create view to v9db;

-- 15服务器对应的Oracle的目录 --
-- D:\dbdata\dbdir --
grant read,write on directory LBS2016DIR to v9db;

-- cmd下面 --
impdp v9db/v9db@IOT_10_21_129_15 DIRECTORY=LBS2016DIR DUMPFILE=VEHEXPDBTEST.DMP schemas=vehicle_test REMAP_SCHEMA=vehicle_test:v9db remap_tablespace=VEHICLE_TEMP:v9db_data logfile=vimpdp.log