Revision: 59860
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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