| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOBINDEX
Hi Chuck,
The LOB index points to the chunks that comprise the LOB. Each index entry points to 4 chunks. Subject to PCTVERSION, changes to LOB data actually create new chunks. This generate redo for both the LOB data and index, but no undo for the LOB data. Read consistency and rollback are achieved merely by rolling back the LOB index changes. In 8.0 you can name the LOB index and store it in its own tablespace. In 8.1 you cannot.
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/
-----Original Message-----
From: Chuck Hamilton [SMTP:chuck_hamilton_at_yahoo.com] Sent: Thursday, July 06, 2000 3:34 AM To: Multiple recipients of list ORACLE-L Subject: LOBINDEX
When I create a CLOB data type, oracle automatically creates a LOBSEGMENT and LOBINDEX segment. I understand the the LOBSEGMENT contains the LOB data. But what the heck is in the LOBINDEX? Why is it needed. Do I need to do anything with it? Is there some way to store it in a different tablespace than the LOBSEGMENT?
 |
 |