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');

exp/imp匯出匯入資料

相關文章