RE: Change tablespace for Local Index Partition

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Wed, 07 Mar 2001 14:58:59 -0800
Message-ID: <F001.002C6703.20010307143829@fatcity.com>

        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 5:06 PM
To: Multiple recipients of list ORACLE-L

Alex,

You have the syntax correct, but your index name seems invalid. Also, there is no need to put double quotes around the tablespace name.

alter index <index name> rebuild partition <partition name> tablespace <tablespace name>

is correct, though.

HTH, Diana

-----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: Alex.Berindei_at_elsag.it

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

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

Author: Diana Duncan
  INET: dduncan_at_arsenaldigital.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).
--

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

Author: Vadim Gorbounov
  INET: vgorbounov_at_simplyengineering.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 Wed Mar 07 2001 - 16:58:59 CST