8 Replies Latest reply on Sep 17, 2011 5:11 PM by rukbat

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

    101265
      got the error messages that said "ORA-01536: space quota exceeded for tablespace 'USERS" any idea or suggestion? i will appreciate your help.


      SQL> CREATE TABLE customer(
      2 CST_ID NUMBER,
      3 FIRST_NAME VARCHAR2(30) not null,
      4 LAST_NAME VARCHAR2(30) not null,
      5 STREET_ADDRESS VARCHAR2(60),
      6 CITY VARCHAR2(30),
      7 STATE CHAR(2),
      8 ZIP VARCHAR2(11),
      9 COUNTRY VARCHAR2(18),
      10 PHONE VARCHAR2(15),
      11 EMAIL VARCHAR2(45),
      12 ALT_EMAIL VARCHAR2(45),
      13 WORK_PHONE VARCHAR2(15),
      14 CONSTRAINT CUSTOMER_PK PRIMARY KEY (CST_ID));
      CREATE TABLE customer(
      *
      ERROR at line 1:
      ORA-01536: space quota exceeded for tablespace 'USERS'