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
ssk8181
Messages: 6
Registered: February 2006
Location: Chennai
Junior Member
Hi,

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
PCTVERSION 5
ENABLE STORAGE IN ROW
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.

Thanks
Senthil.
Re: Adding new LOB column [message #235451 is a reply to message #174801] Sun, 06 May 2007 03:51 Go to previous message
aciolac
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: Sun Dec 11 08:30:12 CST 2016

Total time taken to generate the page: 0.21415 seconds