01536, 00000, "space quota exceeded for tablespace '%s'"
// *Cause:  The space quota for the segment owner in the tablespace has
//          been exhausted and the operation attempted the creation of a
//          new segment extent in the tablespace.
// *Action: Either drop unnecessary objects in the tablespace to reclaim
//          space or have a privileged user increase the quota on this
//          tablespace for the segment owner.

sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jun 16 09:53:42 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> alter user system quota unlimited on users;

User altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> alter user system account unlock;
alter user system account unlock
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01536: space quota exceeded for tablespace 'TOOLS'
ORA-06512: at line 2

SQL> select distinct trigger_type, triggering_event from dba_triggers where owner != 'SYS' order by 1,2
  2  ;
AFTER EACH ROW   DELETE
AFTER EACH ROW   INSERT
AFTER EACH ROW   INSERT OR UPDATE
AFTER EACH ROW   INSERT OR UPDATE OR DELETE
AFTER EACH ROW   UPDATE
AFTER EVENT      DDL
AFTER EVENT      LOGON
AFTER STATEMENT  INSERT OR UPDATE OR DELETE
AFTER STATEMENT  UPDATE
AFTER STATEMENT  UPDATE OR DELETE
BEFORE EACH ROW  DELETE
BEFORE EACH ROW  INSERT
BEFORE EACH ROW  INSERT OR UPDATE
BEFORE EACH ROW  INSERT OR UPDATE OR DELETE
BEFORE EACH ROW  UPDATE
BEFORE EACH ROW  UPDATE OR DELETE
BEFORE EVENT     DROP OR TRUNCATE
BEFORE STATEMENT INSERT
INSTEAD OF       INSERT OR UPDATE OR DELETE
 
19 rows selected.

  1* select distinct trigger_type, triggering_event from dba_triggers where owner = 'SYS' order by 1,2
  2  /
AFTER EVENT      DROP
AFTER EVENT      LOGON
AFTER EVENT      STARTUP
BEFORE EVENT     ALTER
BEFORE EVENT     CREATE
BEFORE EVENT     DDL
BEFORE EVENT     DROP
BEFORE EVENT     SHUTDOWN
 
8 rows selected.

SQL> SHOW USER
USER is "SYS"
SQL> SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'TOOLS'; 
 
TOOLS                               16384          65536                       1  2147483645  
                 65536 ONLINE    PERMANENT NOLOGGING NO  LOCAL          SYSTEM    NO  MANUAL DISABLED NOT APPLY   NO
 
SQL> SELECT SUM(BLOCKS) FROM DBA_FREE_SPACE WHERE TABLESPACE_NAME = 'TOOLS'; 
 
     175100
 
SQL> 

 
SQL> show user
USER is "SYS"
SQL> l
  1* select owner, trigger_name, triggering_event from dba_triggers where triggering_event in ('DDL','ALTER') order by 1,2
SQL> /
 
no rows selected
 
SQL> 

SQL> SELECT COUNT(*) FROM dba_triggers where TRIGGERING_EVENT = 'DDL' ;
 
         0
 
SQL> 

select owner, trigger_name, triggering_event 
from dba_trigges 
where triggering_event like 'DDL%'
   or triggering_event like 'ALTER%'
order by 1,2;

SQL> SELECT COUNT(*) FROM dba_triggers where TRIGGERING_EVENT LIKE 'DDL%' ;
 
         3
 

  1  select owner, trigger_name, triggering_event
  2  from dba_triggers
  3  where triggering_event like 'DDL%'
  4     or triggering_event like 'ALTER%'
  5* order by 1,2
SQL> /
 
OWNER                          TRIGGER_NAME                   TRIGGERING_EVENT
------------------------------ ------------------------------ -------------------
ARAO                           DDLTRIGGER                     DDL
SYS                            NO_VM_ALTER                    ALTER
SYS                            TR_DDL_LOCK                    DDL
SYS                            TR_DDL_TRACK                   DDL
 

  1  select owner, trigger_name,status, triggering_event
  2  from dba_triggers
  3  where triggering_event like 'DDL%'
  4     or triggering_event like 'ALTER%'
  5* order by 1,2
SQL> /
 
OWNER                          TRIGGER_NAME                   STATUS   TRIGGERING_EVENT
------------------------------ ------------------------------ -------- --------------------
ARAO                           DDLTRIGGER                     ENABLED  DDL
SYS                            NO_VM_ALTER                    DISABLED ALTER
SYS                            TR_DDL_LOCK                    DISABLED DDL
SYS                            TR_DDL_TRACK                   DISABLED DDL

set long 10000
set longchunksize 100
set linesize 100
select trigger_body 
from dba_triggers 
where owner='ARAO' and trigger_name='DDLTRIGGER';
select bytes, max_bytes 
from dba_ts_quotas 
where tablespace_name='TOOLS' and username='ARAO';

SQL> select trigger_body 
from dba_triggers 
where owner='ARAO' and trigger_name='DDLTRIGGER';
select bytes, max_bytes 
from dba_ts_quotas 
where tablespace_name='TOOLS' and username='ARAO';  2    3  BEGIN
 insert into
   ARAO.stats$ddl_log
 (
   user_name,
   ddl_date,
   ddl_type,
   object_type,
   owner,
   object_name
 )
 VALUES
 (
   ora_login_user,
   sysdate,
   ora_sysevent,
   ora_dict_obj_type,
   ora_dict_obj_owner,
   ora_dict_obj_name
 );
END;
 

SQL> set long 10000
set longchunksize 100
set linesize 100
SQL> SQL> SQL> 
SQL> l
  1  select bytes, max_bytes
  2  from dba_ts_quotas
  3* where tablespace_name='TOOLS' and username='ARAO'
SQL> /
 
no rows selected
 
SQL>