In freesql.com i am trying to create a table but giving me below error “space quota exceeded ” i remember using livesql i would able to create table anything changed please ?
SQL> ALTER TABLE TEST_ARCHIVE ADD PARTITION MAY_2026 VALUES LESS THAN (2026,6) SEGMENT CREATION IMMEDIATE
ORA-01536: space quota exceeded for tablespace 'USERS'
https://docs.oracle.com/error-help/db/ora-01536/
Error at Line: 21 Column: 0
CREATE TABLE "TEST_ARCHIVE"
(
"YEAR\_ID" NUMBER(4,0) NOT NULL ENABLE,
"MONTH\_ID" NUMBER(2,0) NOT NULL ENABLE,
"TEST\_ID" VARCHAR2(100)
)
PARTITION BY RANGE ("YEAR_ID","MONTH_ID")
(
PARTITION p1 VALUES LESS THAN (2025,11) SEGMENT CREATION IMMEDIATE
);
ALTER TABLE TEST_ARCHIVE ADD PARTITION NOV_2025 VALUES LESS THAN (2025,12) SEGMENT CREATION IMMEDIATE;
ALTER TABLE TEST_ARCHIVE ADD PARTITION DEC_2025 VALUES LESS THAN (2025,1) SEGMENT CREATION IMMEDIATE;