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 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).
