Home » RDBMS Server » Server Administration » BLOB Creation
BLOB Creation [message #53116] Wed, 28 August 2002 10:06 Go to next message
jhonken
Messages: 1
Registered: August 2002
Junior Member
I'm trying to create a table with a BLOB in it. I'm using the following script:

CREATE TABLE eliglog_history (
transaction_id NUMBER(9,0) DEFAULT 0 NOT NULL,
request blob,
response blob)
TABLESPACE test
/

I get the error "ERROR at line 1:
ORA-03001: unimplemented feature
"

Can someone please tell me what is wrong. I'm using Oracle 9i on Linux. Thanks

Report message to a moderator

Re: BLOB Creation [message #53117 is a reply to message #53116] Wed, 28 August 2002 10:40 Go to previous messageGo to next message
SKS
Messages: 26
Registered: February 2002
Junior Member
This problem is caused by a documented restriction of the use of
SEGMENT SPACE MANAGEMENT in 9.0.1 - LOBs cannot be stored in tablespaces created
with SEGMENT SPACE MANAGEMENT set to AUTO.

Report message to a moderator

Re: BLOB Creation [message #53120 is a reply to message #53116] Wed, 28 August 2002 11:07 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You cannot create LOB segments in locally managed tablespaces in Oracle 9.0.1.0.0.

Either upgrate to 9.0.2.0.0 or user dictionary managed tablespace.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Logging related question
Next Topic: Cna I encode oracle db data in utf-8?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 12:45:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.