Advanced Search

Return to Snippet

Revision: 59860
at October 5, 2012 05:38 by thescorpion
Initial Code 
--1 consulta el archivo relacionado al tablespace
SELECT
   df.tablespace_name,
   df.file_name,
   df.bytes/1024 Allocated_kb,
   free.free_kb,
   Round(free.free_kb/(df.bytes/1024)*100) Percent_Free
FROM
   dba_data_files df,
   (SELECT file_id, SUM(bytes)/1024 free_kb
    FROM dba_free_space GROUP BY file_id) free
WHERE
   df.file_id=free.file_id
ORDER BY
   Percent_Free;


---2 aumentar el tamAnio de ese archivo
ALTER DATABASE   DATAFILE '/opt/app/oracle/oradata/otelo/TBSP_COB.ORA' RESIZE  10120M
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
incremento del table space en oracle

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Aumentar tamaño al Tablespace en oracle

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL