// 創建表空間
create temporary tablespace TESTDB_TEMP
tempfile 'C:/TESTDB_TEMP.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
// 創建數據表空間
create tablespace TESTDB_DATA
logging
datafile 'C:/TESTDB.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
// 創建用戶
create user testdb identified by testdb
default tablespace TESTDB_DATA
temporary tablespace TESTDB_TEMP
// 給用戶授予權限(以下權限是匯入數據需要的權限)
grant CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO testdb
// 匯入DB
"開始" > "執行" > "cmd"
imp test db/testdb@TTDB c:\UAT20130101.dmp full=y
imp 用戶名/密碼@數據庫名稱 數據庫dmp文件路徑 full參數表示是否將整個數據庫導入
// 匯入DB
exp testdb/testdb@TTDB c:\UAT20130101.dmp full=y
create temporary tablespace TESTDB_TEMP
tempfile 'C:/TESTDB_TEMP.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
// 創建數據表空間
create tablespace TESTDB_DATA
logging
datafile 'C:/TESTDB.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
// 創建用戶
create user testdb identified by testdb
default tablespace TESTDB_DATA
temporary tablespace TESTDB_TEMP
// 給用戶授予權限(以下權限是匯入數據需要的權限)
grant CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO testdb
// 匯入DB
"開始" > "執行" > "cmd"
imp test db/testdb@TTDB c:\UAT20130101.dmp full=y
imp 用戶名/密碼@數據庫名稱 數據庫dmp文件路徑 full參數表示是否將整個數據庫導入
// 匯入DB
exp testdb/testdb@TTDB c:\UAT20130101.dmp full=y