How about a create table as select and then rename the table?
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Randy Harris" <randy_at_SpamFree.com> wrote in message
news:QZngb.54$GE4.50322_at_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 - 20:04:05 CDT
