ITPub博客

首页 > 应用开发 > IT综合 > imp,exp

imp,exp

原创 IT综合 作者:pentium 时间:2013-03-04 17:24:17 0 删除 编辑
here are some examples on exp/imp:[@more@]
1. after drop the user, use below to create first.

create user cog84cs identified by welcome1 DEFAULT TABLESPACE COGNOS_APP TEMPORARY TABLESPACE TEMP;
GRANT UNLIMITED TABLESPACE TO cog84cs;

2. and get the privs info:
select * from DBA_SYS_PRIVS where grantee in ('COG84CS','CG84ADTD');
select * from DBA_TAB_PRIVS where grantee in ('COG84CS','CG84ADTD');
select * from DBA_ROLE_PRIVS where grantee in ('COG84CS','CG84ADTD');

nohup imp "/ as sysdba" file=/db01/cognos8.dmp log=/db01/cognos8)imp.log fromuser=(cog84cs,cg84adtd) touser=(cog84cs,cg84adtd) feedback=10000 buffer=100000000 &


*********************************************************************************************************
full db exp:
nohup exp "/ as sysdba" file=cogdbdexp.dmp log=cogdbdexp.log feedback=10000 consistent=y statistics=none indexes=y full=y buffer=100000000 Compress=Y &

full db imp:
before imp, use this statement to generate drop statement to drop all default oracle generated schemas:

select 'drop user '|| username||' cascade;' from dba_users where username not in ('SYS','SYSTEM','OUTLN','DIP','TSMSYS','DBSNMP','WMSYS','EXFSYS','XDB','ANONYMOUS','ORACLE_OCM','DBMON','DBA');

nohup imp "/ as sysdba" file=/db01/oraback/cogdbd/exp/cogdbdexp.dmp log=/tmp/cogdbdimp.log feedback=10000 buffer=100000000 full=y &


*****************************************************************************************************

exp "/ as sysdba" file=%DMPFILE% log=%LOGFILE% tablespaces=(SYSTEM,SYSAUX,USERS,ARC_SYSTEM_DATA,ARC_SYSTEM_INDEX) direct=Y STATISTICS=NONE

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/14377/viewspace-1060256/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-09-30

  • 博文量
    191
  • 访问量
    327272