//創(chuàng)建臨時表空間
create temporary tablespace test_temp
tempfile 'D:\oracle\data\test\test_temp.dbf'
size 32m
autoextend on
next 32m
extent management local;

//創(chuàng)建數(shù)據(jù)表空間
create tablespace test_data
logging
datafile 'D:\oracle\data\test\test_data.dbf'
size 1024m
autoextend on
next 32m
extent management local;

創(chuàng)建用戶：
create user test_user identified by 123456;
grant dba to test_user;

創(chuàng)建導(dǎo)入/導(dǎo)出路徑：
create directory my_dire as 'd:\db_bak\dump';
grant read, write on directory my_dire to test_user;

導(dǎo)入、導(dǎo)出

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 數(shù)據(jù)庫備份