Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can a table be converted to an IOT?
8.1.7.4 - Guess I'm going to have to do it manually, huh?
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:ujmgb.2049$kj4.817_at_news02.roc.ny...
> In 9i, you can use the online redefinition feature to convert a HOT to
IOT.
> What version are you using?
>
> Anurag
>
> "Randy Harris" <randy_at_SpamFree.com> wrote in message
news:jbmgb.35$GE4.31913_at_newssvr28.news.prodigy.com...
> > Next rookie question...
> >
> > Can a table be ALTERED to an Index Organized Table, or must it be
DROPped
> > and recreated?
> >
> >
>
>
Received on Mon Oct 06 2003 - 19:42:24 CDT