//創建臨時表空間
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

oracle 數據庫備份