第35次：2015-04-14

botang

1. 
   
2. 
   
3. select  * from dba_tablespaces;
   
4. 
   
5. create tablespace tbsfda datafile size 50M autoextend on ;
   
6. 
   
7. create flashback archive default  fda1
   
8. tablespace tbsfda quota 100M  retention  10  year;
   
9. 
   
10. select * from dba_flashback_archive;
    
11. 
    
12. select  * from dba_flashback_archive_ts;
    
13. 
    
14. select * from dba_flashback_archive_tables;
    
15. 
    
16. select * from dba_sys_privs p where p.privilege like 'FLASH%';
    
17. 
    
18. grant  flashback archive   on fda1  to hr;
    
19. 
    
20. grant  flashback archive   on fda2  to hr;
    
21. 
    
22. 
    
23. create flashback archive  fda2
    
24. tablespace tbsfda quota 100M  retention  20  year;
    
25. 
    
26. 
    
27. alter flashback archive fda2 set default;
    
28. 
    
29. select * from dba_flashback_archive_tables;
    
30. 
    
31. select  * from hr.SYS_FBA_HIST_78645;
    
32. 
    
33. alter table hr.t05311_fda1 no flashback archive;
    
34. 
    
35. 
    
36. select  * from hr.SYS_FBA_HIST_78646;

复制代码