Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can a table be converted to an IOT?

Re: Can a table be converted to an IOT?

From: Randy Harris <randy_at_SpamFree.com>
Date: Tue, 07 Oct 2003 00:42:24 GMT
Message-ID: <QZngb.54$GE4.50322@newssvr28.news.prodigy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US