第33次:2014-09-02

botang

1. select  * from dba_Temp_files;
   
2. 
   
3. alter tablespace temp add tempfile '/home/oracle/temp02.dbf' size 50M autoextend on maxsize 10G;
   
4. 
   
5. alter tablespace temp drop tempfile '+DATA/orcl/tempfile/temp.264.816169645';
   
6. 
   
7. select  * from v$log;
   
8. 
   
9. select  * from v$logfile;
   
10. 
    
11. alter database drop logfile group 1;
    
12. 
    
13. alter database add logfile group 1 ( '/home/oracle/redo01a.log', '/home/oracle/redo1b.log') size 50M;
    
14. 
    
15. alter database drop logfile group 3;
    
16. 
    
17. alter database add logfile group 3 ( '/home/oracle/redo03a.log', '/home/oracle/redo3b.log') size 50M;
    
18. 
    
19. alter system switch logfile;
    
20. 
    
21. alter system checkpoint;
    
22. 
    
23. alter database drop logfile group 2;
    
24. 
    
25. alter database add logfile group 2 ( '/home/oracle/redo02a.log', '/home/oracle/redo2b.log') size 50M;
    
26. 
    
27. select   i.index_name , i.degree,  i.blevel  from dba_indexes i where i.owner='HR' and i.index_name='IBIG';
    
28. 
    
29. alter index hr.ibig noparallel;
    
30. 
    

复制代码