From vgorbounov@simplyengineering.com Wed, 07 Mar 2001 14:58:59 -0800 From: Vadim Gorbounov Date: Wed, 07 Mar 2001 14:58:59 -0800 Subject: RE: Change tablespace for Local Index Partition Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 rebuild partition tablespace 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@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@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@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@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@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@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).