第36次：2015-04-16星期四

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;

复制代码

1. select  * from dba_recyclebin;
   
2. 
   
3. select * from dba_segments s where s.segment_name like '%T05311_BIN2';
   
4. 
   
5. select  * from dba_recyclebin;
   
6. 
   
7. 
   
8. select  * from dba_indexes i where i.owner='HR' and i.table_name='T05311_BIN2';
   
9. 
   
10. alter index  hr."BIN$E9e/ZQ8+DLvgUKjAWgBxZQ==$0" rename to pk_T05311_BIN2;
    
11. 
    
12. select    sum(bytes)/1024/1024    from dba_data_files where tablespace_name='USERS';
    
13. 
    
14. select  sum(bytes)/1024/1024   from dba_free_space where tablespace_name='USERS';
    
15. 
    
16. purge tablespace users  user hr;
    
17. 
    
18. purge tablespace users;
    

复制代码