ORA-01536: space quota exceeded
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01536: space quota exceeded

  1. #1
    Join Date
    May 2001
    Posts
    28

    Question

    Just recently we have been getting the following (lots) errors on different instances that we have.

    ORA-01536: space quota exceeded for tablespace 'xyz'

    Can someone direct me to a script that will help me monitor the space quota?

    I appreciate all you help!

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    TS quota monitor

    Hi, 16th May 2001 13:56 hrs *******

    There are several scripts like this available from third parties.

    set verify on
    set feedback off
    set wrap off
    set pagesize 60
    set linesize 72
    set newpage 0
    set space 10
    set trimout on
    set underline =
    set echo off
    set termout off

    whenever sqlerror exit failure

    spool tsquota.rslt

    ttitle center 'TSQUOTA - DBA TS Quotas Report ' skip 1 -
    left "PAGE:" sql.pno format 999 -
    right CWS_DATE skip 2
    col username format A8
    col tablespace_name format A14 heading Tablespace
    col bytes format 999,999,999
    col blocks format 999,999

    compute sum of bytes on tablespace_name
    compute sum of blocks on tablespace_name

    break on tablespace_name skip 1

    select tablespace_name,
    username,
    bytes,
    blocks
    from sys.dba_ts_quotas
    where tablespace_name <> 'SYSTEM'
    order by tablespace_name,
    username;

    spool off;
    exit

    Cheers

    padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width