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.

--
http://www.freelists.org/webpage/oracle-l