Re: Error at moving tables from tablespace to another
- From: Rajesh Aialavajjala <r.aialavajjala@xxxxxxxxx>
- To: dmarc-noreply@xxxxxxxxxxxxx
- Date: Wed, 5 Nov 2014 08:30:33 -0500
Mostafa,
It appears from the error that you are trying to move an IOT (Index
Organized Table) to a new tablespace.
Please see the following MOS Notes...
How To Move An IOT Table To Another Tablespace (Doc ID 453997.1)
How to Move an Index Organized Tables' Overflow Segment to Another
Tablespace (Doc ID 1448359.1)
Index Organized Tables (IOTs) (Doc ID 50874.1)
External references that cite examples...
http://nitish-oracledbaforum.blogspot.com/2011/11/how-to-move-iot-into-another-tablespace.html
http://www.orafaq.com/wiki/Index-organized_table
http://oracle-base.com/articles/8i/index-organized-tables.php
Hope this helps...
Thanks,
--Rajesh
On Wed, Nov 5, 2014 at 7:50 AM, Mostafa Eletriby <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
> Hello All,
> I have a problem regarding moving tables to another tablespace or same
> tablespace
> From sysaux tablespace and from another tablespaces , show same error.
> DB version: 11.2.0.2
> O.s : Windows server 2008 R2 Enterprise Edition
>
>
> ALTER TABLE <table name> MOVE TABLESPACE <tablespace name> ;
> ALTER TABLE <table name> MOVE TABLESPACE ;
>
> ORA-25191: cannot reference overflow table of an index-organized table
>
> I searched a lot at MOS and googled the error but I am not sure of it is a
> bug & I may have to upgrade DB.
>
> (Doc ID 49763.1)
>
> Please advice.
> Regards,
>
>
Other related posts:
