Hi, Alex,

1. Can I ask you, what's UT.222? If UT supposed to be oracle schema, 222 is
not valid index name. 
2. You can specify tablespace for EVERY next index partition, if you specify
CREATE INDEX ... TABLESPACE xxx and then move all partitions wherever you
want. After all new partition will go to TABLESPACE xxx.

        Vadim Gorbounov
        Oracle DBA
        


-----Original Message-----
Sent: Wednesday, March 07, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L



Hi,

I'm running Oracle 8.0.5 and I have a partitioned table with local indexes.
I try to: put partition data and partitioned indexes in different
tablespaces.

As you probably know Oracle when you create a new table partition creates
implicit local indexes partitions, but you cannot specify to put them in a
specific tablespace.

I issue command:

 SQL>ALTER INDEX UT.222 REBUILD PARTITION M3 TABLESPACE "TSM_IX_3" ;
 ORA-02243: invalid ALTER INDEX or ALTER SNAPSHOT option

Do you know any command which will work?

Thx Alex.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Berindei Alex
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  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).

Reply via email to