Ron, I share your feeling. All stored objects are recreated with CREATE OR REPLACE - IGNORE=Y is inoperant for them. IMHO the best you can do is generate as many table-level exports as you have tables, with TRIGGERS=N. Of course, usual fun with constraints. On the bright side, you will be able to parallelize like crazy. At this stage, dumping to a flat file and using sqlldr might be an even better option than imp/exp.
HTH S Faroult >----- ------- Original Message ------- ----- >From: "Smith, Ron L." <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Fri, 09 Jan 2004 06:09:26 > >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: Stephane Faroult 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).
