oracle 数据库备份

//创建临时表空间
create temporary tablespace test_temp
tempfile 'D:\oracle\data\test\test_temp.dbf'
size 32m
autoextend on
next 32m
extent management local;

//创建数据表空间
create tablespace test_data
logging
datafile 'D:\oracle\data\test\test_data.dbf'
size 1024m
autoextend on
next 32m
extent management local;

创建用户：
create user test_user identified by 123456;
grant dba to test_user;

创建导入/导出路径：
create directory my_dire as 'd:\db_bak\dump';
grant read, write on directory my_dire to test_user;

导入、导出

expdp test_user/123456 directory=my_dire dumpfile=test_user.dmp logfile=test_user_exp.log

impdp test_user/123456 directory=my_dire dumpfile=test_user.dmp logfile=test_user_imp.log remap_schema=test_user:test_user2 remap_tablespace = test_data:test_data2

转载于:https://www.cnblogs.com/vvonline/p/4096509.html