Database Administration (MOSC)

MOSC Banner

ora-28668: cannot reference mapping table of an index-organized table

edited Mar 14, 2010 5:16PM in Database Administration (MOSC) 6 commentsAnswered
oracle 10.2.0.3 on windows 2003 server

Below I moved a mapping table to a different tablespace.

alter table FONTUS.TRA_TX_MAP move mapping table tablespace USERS;

when I do this then I notice I gain an object in the dba_tables named:

table_name=sys_iot_map_254908

iot_type = iot_mapping

iot_name = tra_tx_map (which is the original table).

So when I compare table counts from before the move to after I now have one extra table.  I can't drop the sys_iot_map_254908 table, so I then look into dropping the index that is associated but I am not sure how to build it back and oem does not seem to have the ddl for this index organized table. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center