常用Oracle语句备份

1 -- drop user EBOOKRIGHTS cascade;
2  
3   -- Create the user EBOOKRIGHTS
4   create user EBOOKRIGHTS
5 identified by "12345"
6 default tablespace USERS
7 temporary tablespace TEMP
8 profile DEFAULT ;
9   -- Grant/Revoke role privileges
10 grant aq_administrator_role to EBOOKRIGHTS with admin option ;
11 grant connect to EBOOKRIGHTS with admin option ;
12 grant dba to EBOOKRIGHTS with admin option ;
13 grant resource to EBOOKRIGHTS with admin option ;
14 -- Grant/Revoke system privileges
15 grant delete any table to EBOOKRIGHTS;
16 grant insert any table to EBOOKRIGHTS;
17 grant select any table to EBOOKRIGHTS;
18 grant unlimited tablespace to EBOOKRIGHTS with admin option ;
19 grant update any table to EBOOKRIGHTS;

 

 

1 exp system / eport@ebook file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp full = y log = D: \ dcis \ DB \ bak \ log \ ebook20100119 . log
2
3 exp system / eport@ebook file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp owner =( EBookRights , JITSERVICE ) log = D: \ dcis \ DB \ bak \ log \ ebook20100119 . log
4
5 imp system / eport@ebook34 file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp fromuser =( PUB_REF , PUB_PARA , EBOOKRIGHTS , OFFLINE_EMS3 , OFFLINE_DEC , JITSERVICE ) log = D: \ dcis \ DB \ bak \ ebook20100119_3 . log buffer = 10240000

 

转载于:https://www.cnblogs.com/Jason_zhu/archive/2010/09/14/1826057.html