Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!
Guys,
CREATE TABLE "NAO"."MSG" (
"MEMNO" NUMBER(10, 0),
"PROFNO" NUMBER(10, 0),
"NAME" VARCHAR2(20),
"AGE" VARCHAR2(10),
"SEX" NUMBER(1, 0),
"JANLNO" NUMBER(5, 0),
"SUBJECT" VARCHAR2(50),
"CONTENT" VARCHAR2(500),
"DELFLAG" NUMBER(1, 0) DEFAULT 0,
"POSTDATE" DATE DEFAULT SYSDATE,
"EXPDATE" DATE,
"POSTNO" NUMBER(10, 0),
"REFCNT" NUMBER(5, 0) DEFAULT 0,
"PREF" VARCHAR2(10),
"AREA" NUMBER(2, 0),
"SBSTCNT" NUMBER(5, 0) DEFAULT 0,
"SENDFLG" NUMBER(1, 0) DEFAULT 0,
"REPLYCNT" NUMBER(5, 0) DEFAULT 0,
"CHKFLG" NUMBER(1, 0) DEFAULT 0,
"ENTPC" VARCHAR2(10),
"STOPFLG" NUMBER(5, 0) DEFAULT 0,
"PARENT" NUMBER(10, 0),
"PIC" BLOB,
"PICUPFLG" NUMBER(1, 0) DEFAULT 0
) TABLESPACE "CANDY03"
When i create this table on machine A,i get the error below:
ORA-03001: unimplemented feature
if i remove the BLOB column from the SQL , it works fine on machine A.
whereas,
this works on another machine B with the same o/s and oracle set up.
i wonder why ?
Can you let me know the reason ?
![]() |
![]() |