-
1. Re: How to copy schema from one db to another with different schema name ?
on the first screen, are you selecting
'objects copy'
or
'schemas copy' - with 'maintain' or 'consolidate'
-
2. Re: How to copy schema from one db to another with different schema name ?
My answer isn't related to this specific product, but you can accomplish this with Data Pump and the REMAP_SCHEMA parameter. https://docs.oracle.com/database/121/SUTIL/GUID-619809A6-1966-42D6-9ACC-A3E0ADC36523.htm#SUTIL927
HTH,
Brian
-
3. Re: How to copy schema from one db to another with different schema name ?
I always rec DP to folks, but the main problem is lack of access. Most DBAs won't give developers access to the directories and rights to run Data Pump. But yes, an extremely powerful utility.
-
4. Re: How to copy schema from one db to another with different schema name ?
Hi,
If I select "Schemas copy" - "Maintain schemas" - I could only copy to the same destination schema (if exists)
If I select "Schemas copy" - "Consolidate schemas" - I don't even have an option to define destination schema
>on the first screen, are you selecting
>'objects copy'
>or
>'schemas copy' - with 'maintain' or 'consolidate'
-
5. Re: How to copy schema from one db to another with different schema name ?
use objects copy, then you don't need to worry about schema, I think
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.