i am trying to achieve maximum export and import performance by trying to parallelize both import and export. unfortunately one main schema alone has most of the database objects so user level export and import isn't the best way. and even with that i noticed that the public synonyms where table_owner is the user being exported don't get exported.
are there any other class of objects that user level export ignores?
can i first export (user level) only data followed by indexes alone and finally the triggers and constraints and then import in the same order?
Click Here to Expand Forum to Full Width