exp/imp匯出匯入資料

jelephant發表於2014-04-10
原文網址 : http://blog.itpub.net/29337971/viewspace-1139424/
1、匯出語句
exp usernmae/password file=’/location/back.dmp’ log=’/location/back.log’ owner=’SH’ direct=y

2、賦權語句
select ‘grant ‘ || privilege ||’ to sh;’ from session_privs;
select ‘grant ‘ || role ||’ to sh;’ from session_roles;

3、匯入語句
imp username/password file=’/location/back.dmp’ log=’/location/back.log’ Fromuser=’SH’ touser=’SH’

4、驗證語句
SELECT object_type,count(*) from dba_objects where owner=’SH’ group by object_type;
select tablespace_name,sum(bytes/1024/1024) from dba_segments where owner=’SH’ group by tablespace_name;

5、生成統計資訊
dbms_stast.gather_schema_stats('SH');

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29337971/viewspace-1139424/，如需轉載，請註明出處，否則將追究法律責任。

相關文章