This content has been marked as final. Show 1 reply
export/import (or new brothers for 10g expdp/impdp) should work in most cases.
Actually it seems you are speaking about schemas not databases, so if you have only some tables you can simply grant temporary privileges and issue create table as select * from. There should be problems with constraints and other schema objects though.
But actually you'd better aks this question for example in database - general forum General Database Discussions because it has nothing to do with current forum.