| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 11i cloning help needed
Before cloning, you can create a temp table as select * from fnd_user
and fnd_user_resp_groups where creation_date > (the date since last
clone).
Once the db is cloned, you can import this temp table and insert into the main tables with this data.
If new users and responsibility groups had been added to your production database since the last clone, you'll have issues with unique ID columns that are populated using an index. So, your re-insert program will have to have some logic in it to account for this. I think the best way to design your re-insert program is to turn trace on in "test" as you create a new user - the contents of the trace file should shed light on the logic Oracle uses on the form.
Hope this helps.
-----Original Message-----
sreenivasa
Sent: Sunday, February 16, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L
Hi DBA's
Need some help in post cloning.
DB: 8i
OS: SOlaris 2.8
Apps: 11i
Every sunday my test database
(including TOPs (APPL_TOP and other tops))
is refreshed with production (cloned). It is 11i
(11.5.5)
When it is refreshed, I am loosing my newly created users and their responsibilities etc.
I want to retain them in my test instance. I guess, I would take some tables export before cloning and import them into test instance after cloning.
But I am not clear which tables I have to take export.
Can someone guide me, how to do this and what tables to use in this process ?
Thanks in advance,
Srinivas
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: kommacnu_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Sun Feb 16 2003 - 09:53:42 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Clarke INET: jclarke_at_centroidsys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |