Re: Can a table be converted to an IOT?

"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:9iogb.695009$Ho3.150203_at_sccrnsc03...
> How about a create table as select and then rename the table?
> Jim

That sounds like the simplest way. I guess then all I'd have to do is go recreate any needed constraints, right?

> 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 - 23:07:34 CDT