I have a table defined as table1(column1 number38, column2
varchar2(200)).

Column1 is an indexed primary key (well, I guess all pk's are indexed
aren't they?).



Anyhow,

Table's growing to the point where it's beneficial to have an index on
column2, but now I may as well just make this an index organized table.

This is a production table, so prefer to have no/minimum downtime. Just
altering the pk definition and still having a separate table / index
feels like a waste of space.

Ideas / suggestions on how to migrate this to an IOT?



Thanks.






Oracle LazyDBA home page