敗家貓

os:rhce 4.0
linux:10.1.2

備份跟還原測試機器上先建立相同的環境，進入sql

create user expdbuser identified by expdbuser default tablespace expdb temporary tablespace temp;
grant dba to expdbuser;
create directory expdb_dir as '/u01/expdb';
grant read, write on directory expdb_dir to expdbuser;
建立用戶可看情況是否要新增

建立實體目錄，使用os指令
mkdir -p /u01/expdb
chown oracle:oinstall /u01/expdb
chmod 775 /u01/expdb


export語法
expdp expdbuser/expdbuser directory=expdb_dir dumpfile=t_user.dmp tables=km.t_user


import語法
impdp expdbuser/expdbuser directory=expdb_dir dumpfile=t_user.dmp


在import時要注意，tablespace要自已建立，以免import時會發生錯誤

CREATE SMALLFILE TABLESPACE "TESTDB"
DATAFILE '/u01/app/oracle/apmdb/testdb.dbf' SIZE 100M 
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED 
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO 

如何將得到dump出來的檔案轉成sql呢?

impdp expdbuser/expdbuser directory=expdb_dir dumpfile=t_user.dmp sqlfile=t_user.sql

附記
http://www.oracle.com/technology/pub/articles/10gdba/week4_10gdba.html
http://www.eygle.com/archives/2005/04/ecineeeeiaeioae.html
http://oracle.chinaitlab.com/backup/21329.html