When I try to export and then import many schemas from one Oracle DB to another one, I get errors because grants and synonyms cannot be recreated in the target DB; the reason is probably that the schemas are not imported in the right order.
So :
- With impdp, is it possible to define the order in which the schemas are to be imported ?
- If not (and I think that impdp simply uses the order in which the schemas were found in the dump file) : is it possible during the expdp to define the order in which the schemas are to be exported ?