第47次： 2014-10-14

botang

1. select  * from dba_directories;
   
2. 
   
3. select  * from dba_tab_privs tp where tp.grantee='HR';
   
4. 
   
5. select  * from dba_datapump_jobs;
   
6. 
   
7. select  * from full_job;
   
8. 
   
9. select  username from dba_users;
   
10. 
    
11. select  * from dba_objects o where o.owner='HR';
    
12. 
    
13. grant resource , connect to hr;
    
14. 
    
15. grant all on directory dir1 to hr;
    
16. 
    
17. select  * from dba_source where name='SECURE_EMPLOYEES';

复制代码

1. expdp hr/oracle_4U  directory=dir1 dumpfile=t_bank_invoice.dmp  tables=T_BANK_INVOICE
   
2. 
   
3. impdp  hr/oracle_4U directory=mydir dumpfile=t_bank_invoice.dmp
   
4. 
   
5. expdp \'sys/oracle_4U as sysdba\' attach=full_job
   
6. 
   
7. impdp  \'sys/oracle_4U as sysdba\' directory=dir1 dumpfile=full.img schemas=hr
   
8. 
   
9. expdp hr/oracle_4U directory=dir1 dumpfile=my.dmp  schemas=hr job_name=my_job  exclude=table:"in \(\'T_BANK_INVOICE\'\)", procedure:" in \(\'SECURE_DML\'\)"  "query='employees:where department_id=90'"
   
10. 
    
11. 
    
12. SQL> conn / as sysdba
    
13. Connected.
    
14. SQL> create user hr identified by oracle_4U ;
    
15. 
    
16. User created.
    
17. 
    
18. SQL> grant connect , resource to hr;
    
19. 
    
20. Grant succeeded.
    
21. 
    
22. impdp  \'sys/oracle_4U as sysdba\' directory=dir1 dumpfile=full.img schemas=hr
    
23. 
    
24. expdp  \'sys/oracle_4U as sysdba\' directory=dir1 dumpfile=tablespace.dmp  tablespaces=tbs05217
    
25. 
    
26. impdp \'sys/oracle_4U as sysdba\' directory=mydir dumpfile=tablespace.dmp  remap_tablespace=TBS05217:USERS
    
27. 
    

复制代码

my2.par:

1. directory=dir1
   
2. dumpfile=my2.dmp  
   
3. schemas=hr
   
4. job_name=my2_job  
   
5. exclude=table:"in ('T_BANK_INVOICE')", procedure:"in ('SECURE_DML')"  
   
6. query='employees:where department_id=90'
   
7. flashback_time='2014-10-14:20:34:12'

复制代码