Collapse partitions in 9i - What all options do i have?

Hi All,

We are in the process of migrating our Enterprise Edition 9i db to Standard
Edition 9i. As we all are aware, Partitioning is not enabled in the Standard
Edition, we would like to collapse all the partitions in our db before
migrating it to Standard Edition. The current DB (Enterprise Edition) has 45
tables with partitions with around a million records on an average in each
table. The worst part is there is no primary key on these tables. Initially
i thought an Online Redefinition of the tables will fix the thing for me,
but the absence of Primary Keys makes this impossible. The data so far i
have gathered is this:

1) Online Redefinition is possible - But we do not have Primary keys - Can
we do with ROWIDs? If yes, how?
2) ALTER TABLE EXCHANGE PARTITION can be feasible - But i am not much aware
of this option?
3) Tried checking if Export/Import will help but i dont think this will.

What are the various ways i have to collapse partitions in a DB?

Thanks a lot in advance,
Vikram Singh,
Consultant DBA,
Sierra Atlantic S/W Services Ltd.,
Hyderabad,
Andhra Pradesh - 509028
India.

Other related posts: