| 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: Need help in moving LOB index
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
-----Original Message-----
Winnie_Liu_at_infonet.com
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: japplewhite_at_inetprofit.com
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: ListGuru_at_fatcity.com (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). Received on Thu Feb 15 2001 - 16:22:08 CST
 |
 |