| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving data between tablespaces[Scanned]
Karthik,
You need to rebuild your indexes after moving your table as they are invalidated with the move.
HTH,
-- Alan Davey adavey_at_competitrack.com 212-604-0200 x106 On 9/17/2002 10:03 AM, Karthikeyan S <skarthik_at_globalsw-in.com> wrote:Received on Tue Sep 17 2002 - 09:28:26 CDT
>Thomas / Amar,
>
>I moved the tables from SYSTEM to the DATA tablespace. But now I
>am getting the following error.
>"ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such
>index is in unusable state"
>Is it because of moving the table to a different tablespace or is
>it something else?
>TIA
>
>regards,
>Karthik
>
>-----Original Message-----
>Sent: Tuesday, September 17, 2002 6:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Karthik,
>
>Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.
>
>It will do exactly what you want.
>
>You can also ALTER INDEX {index_name} REBUILD {tablespace} to move
>indexes.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Tuesday, September 17, 2002 4:58 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi All,
>
>Some of my tables are accidentally created in the SYSTEM tablespace.
>
>Is there any way to move the records and the table to some other
>tablespace?
>
>
>regards,
>Karthik
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Karthikeyan S
> INET: skarthik_at_globalsw-in.com
>
>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: 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: Alan Davey INET: adavey_at_competitrack.com 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: 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).
 |
 |