Enterprise Manager

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-01429: Index-Organized Table: no data segment to store overflow row-pie

575300Jun 4 2007 — edited Jun 4 2007

Could anyone tell me why I keep on getting this error whenever I try to excute this statements ?

create table personalSTATUS
(RESUMEID NUMBER(10) NOT NULL,
ID NUMBER(10) NOT NULL,
TYPE NVARCHAR2(255),
VALUE NVARCHAR2(255),
TITLE NVARCHAR2(255),
CODE NVARCHAR2(255),
STARTDATE NVARCHAR2(40),
ENDDATE NVARCHAR2(40),
NOTE NVARCHAR2(700),
CONSTRAINT personalSTATUS PRIMARY KEY (RESUMEID, ID))

ORGANIZATION INDEX
TABLESPACE EDE_ADS_RESUME

create table personalSTATUS
*

ERROR at line 1:

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2007

Added on Jun 4 2007

1 comment

1,174 views