Home » SQL & PL/SQL » SQL & PL/SQL » Adding new LOB column
Adding new LOB column [message #174801] Tue, 30 May 2006 10:59 Go to next message
Messages: 6
Registered: February 2006
Location: Chennai
Junior Member

I try adding LOB column as mentioned below

ALTER TABLE case_version
ADD (image2 BLOB)
LOB (image2) STORE AS image2_lob_seg (
TABLESPACE cdss_bigobj_data
CHUNK 4096
INDEX image2_lob_idx (
TABLESPACE cdss_bigobj_indx

After running the statement, it says table altered.
The LOB column is created in the cdss_bigobj_data tablespace.
But the index is also created in the cdss_bigobj_data. I have specified there as TABLESPACE cdss_bigobj_indx, I am wondering why it is not created in the cdss_bigobj_indx? Is something wrong with the sql statement?

I tried giving some junk value in place of cdss_bigobj_indx, like abcd, it runs the statement and creates the index in cdss_bigobj_data.

It would be great if you can provide how to create the index in the required tablespace while adding LOB column.

Re: Adding new LOB column [message #235451 is a reply to message #174801] Sun, 06 May 2007 03:51 Go to previous message
Messages: 242
Registered: February 2006
Senior Member
Index for LOB column ALWAYS are created in the tablespace, where are placed LOB segment. This is a rule.
Previous Topic: decode
Next Topic: v$ view
Goto Forum:

Current Time: Fri Aug 18 01:41:09 CDT 2017

Total time taken to generate the page: 0.17745 seconds