Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export / Import Question
Hi Ron,
If it's going to be an ongoing occurance you might want to consider Princeton Softech's "Relational Tools for Servers" suite. In particular, the Move for Servers product.
I use it to populate up to 20 different development / testing environments with a relationally intact subset of data from production. If your database has RI it's a breeze, but even if you don't have RI defined in the database (like we don't) then you just have to teach it the relationships once. Since our production environment is around 1.5TB, Move for Servers makes it a breeze to just extract a sample of 500 customers - enough to test almost all functionality but still nice and small.
I highly recommend this product - and they aren't even paying me to say that!
Regards,
Mark.
"Smith, Ron L." <rlsmith_at_kmg.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent by: cc: ml-errors_at_fatcity Subject: RE: Export / Import Question .com 10/01/2004 04:29 Please respond to ORACLE-L
That would require effort and planning on their part.
Ron
-----Original Message-----
Sent: Friday, January 09, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L
Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, January 09, 2004 8:09 AM
To: Multiple recipients of list ORACLE-L
I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc...
My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will.
If so, is there any way to prevent this?
Thanks!
R Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: rlsmith_at_kmg.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Richard
INET: mrichard_at_transurban.com.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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). Received on Sun Jan 11 2004 - 15:44:26 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message