Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

101265Feb 12 2002 — edited Sep 17 2011
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'
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2011
Added on Feb 12 2002
8 comments
125,318 views