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