RE: Help with IMPort
Hi Raja Kumar, If you don't know what are the differences use the parameters touser and fromuser During importation Oracle will recreate those tables I think if you not use the ignore = y you will get error message since Oracle cannot insert due to different table structure Just guessing If you are not require to know those table structure differences then you can drop the tables first. Other Important Note: Make sure your dump file exported with parameter compress = n Sinardy -Original Message- Sent: 06 January 2003 16:34 To: Multiple recipients of list ORACLE-L I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Sinardy Xing 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).
Re: Help with IMPort
The best method that I know is: 1) export from production. 2) drop user cascade in development or at least drop all tables. 3) create user in development. 4) import into development with indexes=n and constraint=n. 5) import again into development with rows = n and ignore = y. Step 4 will build all the tables with the data. Step 5 will build indexes and enable constraints. If the tables already exist in the target database then import will not recreate them. As for the data you may have constraints that reject the insert of records. Lets say you have a fact table and a lookup table that contain the branches names. On the fact table you have constraint: branch id must be in the branch table. When you import the fact table before the branch table all the records will be rejected because the branch table does not have the ids yet. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 10:33 AM I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Yechiel Adar 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).
RE: Help with IMPort
To fine tune the suggestions aready made, you probably don't want to drop all the table but just tables both in production and development/test. I would create a list of tables exported from production via export / show and use this to create a drop table script. Mike -Original Message- Sent: Monday, January 06, 2003 4:29 AM To: Multiple recipients of list ORACLE-L The best method that I know is: 1) export from production. 2) drop user cascade in development or at least drop all tables. 3) create user in development. 4) import into development with indexes=n and constraint=n. 5) import again into development with rows = n and ignore = y. Step 4 will build all the tables with the data. Step 5 will build indexes and enable constraints. If the tables already exist in the target database then import will not recreate them. As for the data you may have constraints that reject the insert of records. Lets say you have a fact table and a lookup table that contain the branches names. On the fact table you have constraint: branch id must be in the branch table. When you import the fact table before the branch table all the records will be rejected because the branch table does not have the ids yet. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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).
Re: Help with IMPort
You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). = cool amar The best way to express yourself is to be yourself. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Amar Kumar Padhi 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).
RE: Help with IMPort
Amar - I was just thinking about suggesting. And as a bonus, you can test your backups, always a good idea. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). = cool amar The best way to express yourself is to be yourself. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Amar Kumar Padhi 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: DENNIS WILLIAMS 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).
RE: Help with IMPort
Title: RE: Help with IMPort Yeah ... yeah ... but after cloning will you submit the databases for a DNA test to prove that it is a true clone? Oops ... Sorry ... I almost forgot we are talking databases here ... is cloning legal yet? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Help with IMPort
Dennis, Amar - My interpretation of the environment was that dev/test has a different set of tables, some of the tables match production table names but may not have the same columns or data. In this case, my first suggestion to drop matching table names from dev/test is insufficient. Maybe truncating those tables would be a better approach. Copying/cloning production would, of course, wipe out dev/test. If there is ongoing development there, that would be a problem ;) Mike -Original Message- Sent: Monday, January 06, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Amar - I was just thinking about suggesting. And as a bonus, you can test your backups, always a good idea. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). = cool amar The best way to express yourself is to be yourself. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Amar Kumar Padhi 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: DENNIS WILLIAMS 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: Hand, Michael T 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).
RE: Help with IMPort
Michael - Yeah but the developers are always whining about something anyway :-) Just kidding. Yes, timing of the refresh can be an issue. We are looking toward a staging environment. Now that will be identical to production. Then we can execute a script that will create or modify tables and other objects, and test the new release. If all goes well, then the same script can be used on production. The actual test system where the developers play should have more modest requirements in terms of amount of data, frequency of refresh, etc. Anyway, this is the environment we are moving toward. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Dennis, Amar - My interpretation of the environment was that dev/test has a different set of tables, some of the tables match production table names but may not have the same columns or data. In this case, my first suggestion to drop matching table names from dev/test is insufficient. Maybe truncating those tables would be a better approach. Copying/cloning production would, of course, wipe out dev/test. If there is ongoing development there, that would be a problem ;) Mike -Original Message- Sent: Monday, January 06, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Amar - I was just thinking about suggesting. And as a bonus, you can test your backups, always a good idea. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). = cool amar The best way to express yourself is to be yourself. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Amar Kumar Padhi 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: DENNIS WILLIAMS 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: Hand, Michael T 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
RE: Help with Import
Title: RE: Help with Import Dennis, We do almost the same thing that you described. We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we run *all* scripts sent in by developers on this database. It they fail on dayold database, the whole request (and any dependencies) are pulled from the release, if not fixed within 30 minutes from reporting. It has been working very well for us for more than 8 months. We clone 4 such databases of varying sizes everyday. These usually get refreshed after the hot backup on the specific database. The cloning process (and locking down of schema and scrambling of sensitive information is part of cloning) is usually finished by 5:30am except Sunday. Yes, and we use the same script on production ... with different passwords. What do you do for multi-schema releases? We change passwords of all schema to a known value and put conn blah/blah like statements in the script that calls all developer supplied scripts. Once the release is complete, it re-sets all passwords back to what they were, and fires a compile_all script to fix all the invalid stuff. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Help with IMPort Michael - Yeah but the developers are always whining about something anyway :-) Just kidding. Yes, timing of the refresh can be an issue. We are looking toward a staging environment. Now that will be identical to production. Then we can execute a script that will create or modify tables and other objects, and test the new release. If all goes well, then the same script can be used on production. The actual test system where the developers play should have more modest requirements in terms of amount of data, frequency of refresh, etc. Anyway, this is the environment we are moving toward. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Help with Import
Raj - Thanks for sharing the details of how this method works in practice for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Dennis, We do almost the same thing that you described. We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we run *all* scripts sent in by developers on this database. It they fail on dayold database, the whole request (and any dependencies) are pulled from the release, if not fixed within 30 minutes from reporting. It has been working very well for us for more than 8 months. We clone 4 such databases of varying sizes everyday. These usually get refreshed after the hot backup on the specific database. The cloning process (and locking down of schema and scrambling of sensitive information is part of cloning) is usually finished by 5:30am except Sunday. Yes, and we use the same script on production ... with different passwords. What do you do for multi-schema releases? We change passwords of all schema to a known value and put conn blah/blah like statements in the script that calls all developer supplied scripts. Once the release is complete, it re-sets all passwords back to what they were, and fires a compile_all script to fix all the invalid stuff. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, January 06, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Michael - Yeah but the developers are always whining about something anyway :-) Just kidding. Yes, timing of the refresh can be an issue. We are looking toward a staging environment. Now that will be identical to production. Then we can execute a script that will create or modify tables and other objects, and test the new release. If all goes well, then the same script can be used on production. The actual test system where the developers play should have more modest requirements in terms of amount of data, frequency of refresh, etc. Anyway, this is the environment we are moving toward. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
RE: Help with Import
Hi, We use a slightly different approach here... We have a couple of development environments which get refreshed with a subset of data (using Princeton Softech's Move for Servers) every so often. The system testers also have a couple of environments like this. These environments are good for checking basic functionality and for creating specific scenario's to test exception handling, etc. We also have a full volume test environment (about 1TB) which is a complete replica of production - same hardware, same data, only passwords changed. The is refreshed before any significant performance testing where a clean environment is required. The refresh is created by restoring database and archive log files from production and then recovering the database (sorry, I don't know the real nitty gritty since this is not something I do personally). The system test teams verify any database scripts against this environment (after they have been unit tested in one of the development environments). Naturally the volume test environment is the playground for any scripts where performance is a concern. Also, since the environment is normally only a couple of weeks old a lot of data investigations can be done in this environment, saving some load on production. To be honest, having a replica of production like this is a god send. Previously I worked on a large data warehouse where all testing / development environments were tiny by comparison and it was much harder to make any guarantee of performance. Here I can say this script is going to take 25-35 minutes when run in production with confidence. I don't know who convinced the business to duplicate all hardware, but my thanks go out to them. I do know that the volume test servers are nominated as failover servers if for some reason production was down for several days - our system can effectively operate for 2-3 days without a database before data is lost so instant failover isn't required. Regards, Mark. DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: Help with Import [EMAIL PROTECTED] m 07/01/2003 08:33 Please respond to ORACLE-L Raj - Thanks for sharing the details of how this method works in practice for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Dennis, We do almost the same thing that you described. We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we run *all* scripts sent in by developers on this database. It they fail on dayold database, the whole request (and any dependencies) are pulled from the release, if not fixed within 30 minutes from reporting. It has been working very well for us for more than 8 months. We clone 4 such databases of varying sizes everyday. These usually get refreshed after the hot backup on the specific database. The cloning process (and locking down of schema and scrambling of sensitive information is part of cloning) is usually finished by 5:30am except Sunday. Yes, and we use the same script on production ... with different passwords. What do you do for multi-schema releases? We change passwords of all schema to a known