I am migrating from an Enterprise Edition of Oracle 10g to a Standard Edition of Oracle 10g and I was wondering if anyone has experience doing this. I've searched around and I can't really find a definitive answer, but it seems like the features in Enterprise Edition will not smoothly translate to an import into a Standard Edition Oracle instance.
Does anyone have experience doing this? So far I have just tried expdp on Enterprise Edition and impdp into Standard Edition, but the features that exist in Enterprise Edition (like partitioning, etc.) cause errors when importing to Standard Edition.
Best Answer
Try using DBMS_METADATA with a TRANSFORM to disable the storage clauses
This should allow you to get all the table structures in a format that you can create the table in SE. Then you can just import the rows on top of the tables you've created.
You won't be able to do anything about bitmap indexes though.