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.