Advanced Search

Aumentar tamaño al Tablespace en oracle

/ Published in: SQL
Save to your folder(s)
incremento del table space en oracle

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.