Karthik,
You need to rebuild your indexes after moving your table as they are invalidated with
the move.
HTH,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 9/17/2002 10:03 AM, Karthikeyan S <[EMAIL PROTECTED]> wrote:
>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: [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.com
--
Author: Alan Davey
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).
