Replicating the same group in subprod instance with same sysid

[PrashantAmaiy00]

Hi Guys,

We have one requirement where we have to copy the groups from production environment to subprod (Dev and TEST) with same details along with sysid, the main important thing to keep the same sysid in subprod instance. We want to automation so everyday job should run and do the job.

Note: 

1) I don't want to export and import as I want automation no human efforts required and daily we can not export import.

2) We don't want to subscribe the "Instance Data Replication" as it require cost.

3) We don't want to do clone our instance as we can not to it on daily basis.

Any help appreciated.

Regards,

Prashant Amaiy

[Jordan Vignoni]

I think cloning is the only option available.  However, maybe you can create a "Clone Profile" that excludes everything except the sys_user_group table, and then schedule the clone to run daily with the profile.  I haven't done this, but off-the-cuff, it could be worth a shot.

[PrashantAmaiy00]

Hi Jordan,

Thanks for your reply.

We are working on this and exploring different options.

Regards,

Prashant Amaiy