Re: index partition

GLOBAL is the default. If you ommiit the keyowrd, you have essentially created a non-partitioned global index. This is not wrong; but do you want to create a global index?

Arup Nanda
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 12, 2003 4:32 PM

> What if I just not using any LOCAL or GLOBAL for creating index on a
> partitioned table like as I said:
>
> create index xxxx on test1(col2) tablespace users; ------------as you see
no
> LOCAL no GLOBAL is this wrong or NOT?
>
> -----Original Message-----
> Sent: Thursday, June 12, 2003 12:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hamid,
>
> You ae referring to decision between two types of indexes in case of a
> partitioned table. You couls have a LOCAL index, in which case the index
> will partitioned exactly in the same way as the table. The other one is
> GLOBAL index, in which case you simple create an index (unpartitioned, if
> you wish) on the table. The global index may be partitioned but the
> partitioning scheme may not be even remotely close to that of the table.
In
> case of a partitoned table, you have to use the keywords LOCAL or GLOBAL
in
> index creation script to specify what it is.
>
> Hope this helps.
>
> Arup Nanda
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, June 12, 2003 11:55 AM
>
>
> > Dear List,
> >
> > I have a table which partitioned on date range & This table has 10
indexes
> > on it I just wondered do I have to Partitioned all the 10 indexes or
NOT?
> > Example:
> >
> > Create table test(col1 number,col2 number,col3 number,col4 date)
> > tablespace data
> > partition by range(col4)
> > ( partition part1 VALUES LESS THAN (TO_DATE(' 2003-12-30 00:00:00'))
> > ,
> > (partition part2 VALUES LESS THAN (TO_DATE(' 2004-12-30 00:00:00'))
> >
> > can the indexes be like this:
> >
> > create index idx_1 on test(col2)
> > tablespace users
> > OR
> >
> > I have to create all the indexes as partition index?
> >
> > Appreciate your help
> >
> > Thanks,
> >
> > Hamid Alavi
> >
> > Office : 818-737-0526
> > Cell phone : 818-416-5095
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hamid Alavi
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 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: [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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 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: [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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hamid Alavi
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 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: [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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 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: [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).