Home » SQL & PL/SQL » SQL & PL/SQL » Drop overflow table of IOT (10g)
Drop overflow table of IOT [message #352066] Sun, 05 October 2008 16:30 Go to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
How to drop an overflow segment on IOT?


SQL> drop table SYS_IOT_OVER_55206;
drop table SYS_IOT_OVER_55206
           *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table




Found this. Is that the correct way? Thanks.
Re: Drop overflow table of IOT [message #352082 is a reply to message #352066] Mon, 06 October 2008 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes or first drop the original table with PURGE option.

Regards
Michel
Re: Drop overflow table of IOT [message #352170 is a reply to message #352082] Mon, 06 October 2008 08:18 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
Thanks Michel for that command.
Previous Topic: Display Collection
Next Topic: Confusing Error
Goto Forum:
  


Current Time: Thu Dec 08 20:10:42 CST 2016

Total time taken to generate the page: 0.06203 seconds