Winnie,
According to the SQL Reference for 8.1.6 (Create Table):
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates
an index for each LOB column. Oracle names and manages the
LOB indexes internally.
Although it is still possible for you to specify this
clause, Oracle Corporation strongly recommends that you no
longer do so.
Maybe you shouldn't mess with it. I leave mine for Oracle
to manage, concentrating on placing my "regular" and
Intermedia indexes where I want - lot more bang for the buck
there.
Jack
--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
-----Original Message-----
[EMAIL PROTECTED]
Hi all,
I know that it is kind of a stupid question. But I've been
struggling with
the syntax to move the LOB index to a different tablespace.
Would any one
please kindly help me out on this part? Thanks!!
:D
Winnie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
