常用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