Oracle-L: RE: Locally Partitioned Index

From: Koivu, Lisa <Lisa.Koivu_at_efairfield.com>
Date: Mon, 16 Dec 2002 06:54:20 -0800
Message-ID: <F001.0051A2DD.20021216065420@fatcity.com>

Like this?

CREATE INDEX vegas_mart_date_of_sale_idx ON vegas_mart (date_of_sale, julian_run_date) local
tablespace lrg_index_a
/

base table partitions reside in 3 different tablespaces.

Lisa Koivu
Oracle Databonehead Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117

-----Original Message-----
Sent: Monday, December 16, 2002 8:59 AM To: Multiple recipients of list ORACLE-L

Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? Base Table being RANGE Partitioned
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com>
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Koivu, Lisa
INET: Lisa.Koivu_at_efairfield.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------