Re: Can a table be converted to an IOT?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 06 Oct 2003 22:48:58 GMT
Message-ID: <ujmgb.2049$kj4.817@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 - 17:48:58 CDT

This message: [ Message body ]
Next message: Paul Murphy: "Re: differenece in DOS SQL*Plus vs. GUI?"
Previous message: Randy Harris: "Can a table be converted to an IOT?"
In reply to: Randy Harris: "Can a table be converted to an IOT?"
Next in thread: Randy Harris: "Re: Can a table be converted to an IOT?"
Reply: Randy Harris: "Re: Can a table be converted to an IOT?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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