Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!

From: Scott Nealy <my0racle_at_lycos.com>
Date: Wed, 19 Mar 2003 07:25:47 -0400
Message-Id: <24715.322343@fatcity.com>

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 ?

---

Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus Received on Wed Mar 19 2003 - 05:25:47 CST