车辆管理系统备份脚本备存

2017-02-06 11:09:26 访问(1465) 赞(0) 踩(0)

expdp vehicle_test/VEHICLE_TEST@ORCL_10_23_10_104 directory=VEHDIR schemas=vehicle_test dumpfile=VEHICLE22.dmp logfile=VEHICLE22.log reuse_dumpfiles=y 

create temporary tablespace veh5db_temp 
tempfile 'veh5db_temp.dbf' 
size 32m 
autoextend on 
next 32m maxsize 100m 
extent management local; 

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


create user veh5db identified by veh5db 
default tablespace veh5db_data 
temporary tablespace veh5db_temp; 


grant connect,resource to veh5db; 

grant create view to veh5db;

grant read,write on directory VDBDIR to veh5db;

-- grant dba to veh5db;

impdp veh5db/veh5db@orcl DIRECTORY=VDBDIR DUMPFILE=VEHICLE22.DMP REMAP_SCHEMA=vehicle_test:veh5db remap_tablespace=VEHICLE_TEMP:veh5db_data logfile=vimpdp.log