Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting a conventional(heap) table to an IOT

sgalaxyJul 10 2006 — edited Nov 13 2006

Hi ,
Is it possible to transform a convetional table into an Index Organized Table ...????

For example , if we a table in Oracle10g RDBMS , defined as :
CREATE TABLE A(AA NUMBER(3),VAL VARCHAR2(15));
ALTER TABLE A ADD CONSTRAINT AA_PK PRIMARY KEY(AA);

Can we convert it ...????

Thanks , a lot
Simon

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2006

Added on Jul 10 2006

#general-database-discussions

3 comments

553 views