Home » RDBMS Server » Server Administration » Moving Index organized Tables
Moving Index organized Tables [message #59980] Wed, 07 January 2004 05:32 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I have index organized tables that I need to move them to another tablespace. The tables don't show up on dba_tables only show up on dba_segments as index type.
How do I move these tables. Do I move as rebuild index to another tablespace or use move to another tablespace as if they are tables.

Report message to a moderator

Re: Moving Index organized Tables [message #59987 is a reply to message #59980] Thu, 08 January 2004 01:28 Go to previous message
Kadhirvelu
Messages: 4
Registered: January 2004
Junior Member
Hi,
"alter table xxx move tablespace yyy" should work fine.

Report message to a moderator

Previous Topic: ORA-00600 Internal error code [ktsircinfo_num1], [51], [62], [52]
Next Topic: Expiration of VeriSign Class 2/Class 3 Certificates on Jan 7,2004
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:37:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.