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 __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Clarke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
