(52-32)第55次：2016-02-24星期三

admin

（52-32）上完1Z0-053第12章
2016-02-24a.sql：

1. select  * from v$flashback_database_log;
   
2. 
   
3. select  * from v$flashback_database_logfile;
   
4. 
   
5. select * from v$flashback_database_stat;
   
6. 
   
7. select  file_name, bytes/1024/1024   from dba_data_Files  where tablespace_name='EXAMPLE';
   
8. 
   
9. select  * from dba_tablespaces;
   
10. 
    
11. select  * from v$datafile;
    
12. 
    
13. alter tablespace users online;
    
14. 
    
15. alter database datafile '+DATA/orcl/datafile/example.265.816169651' resize 120M;
    
16. 
    
17. alter database datafile '+DATA/orcl/datafile/example.265.816169651' resize 30M;
    
18. 
    
19. alter database flashback off;
    
20. 
    
21. select  * from v$restore_point;
    
22. 
    
23. create restore point rsp1
    
24. guarantee flashback database;
    
25. 
    
26. 
    
27. 
    

复制代码

1. select  distinct substr(t.table_name,3,1)  from dba_tables  t where t.owner='SYS'
   
2. and t.tablespace_name='SYSAUX' and
   
3. t.table_name like 'WR_$%';

复制代码