Posted By

thescorpion on 10/05/12


Tagged

PLSQL DBA tablespace


Versions (?)

Aumentar tamaño al Tablespace en oracle


 / Published in: SQL
 

incremento del table space en oracle

  1. --1 consulta el archivo relacionado al tablespace
  2. SELECT
  3. df.tablespace_name,
  4. df.file_name,
  5. df.bytes/1024 Allocated_kb,
  6. free.free_kb,
  7. Round(free.free_kb/(df.bytes/1024)*100) Percent_Free
  8. FROM
  9. dba_data_files df,
  10. (SELECT file_id, SUM(bytes)/1024 free_kb
  11. FROM dba_free_space GROUP BY file_id) free
  12. WHERE
  13. df.file_id=free.file_id
  14. ORDER BY
  15. Percent_Free;
  16.  
  17.  
  18. ---2 aumentar el tamAnio de ese archivo
  19. ALTER DATABASE DATAFILE '/opt/app/oracle/oradata/otelo/TBSP_COB.ORA' RESIZE 10120M

Report this snippet  

You need to login to post a comment.