Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Saving a group of tables on a database refresh

RE: Saving a group of tables on a database refresh

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 17 Aug 2004 13:23:13 -0400
Message-ID: <543DF856D23431489D4B8028C300FBAB08AC93A6@exchsen0a1mb>


Ron,

You will get a create table error - but the data will be imported if it exists in the dump file.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com] Sent: Tuesday, August 17, 2004 12:14 PM
To: oracle-l_at_freelists.org
Subject: RE: Saving a group of tables on a database refresh

We do it all the time. You will get an error on every table that exists and the data import will be skipped for those tables.

Ron

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Tuesday, August 17, 2004 10:58 AM
To: oracle-l_at_freelists.org
Subject: Saving a group of tables on a database refresh

HP-UX, Oracle 8.1.7.
=20

To refresh the test databases we drop all tables and then import.

=20

=20

=20

We have a request to not blow off or change all tables that start with "OPB_".
=20

=20

=20

I can NOT purge them, but purge everything else. If I use the "ignore=3Dn", will it then leave the OPB_ tables untouched?

=20

I know what it's supposed to do, but has anyone done this in real life with success?

=20

Thanks.

=20

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
 <mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com=20

************************************************=20
The information transmitted is intended solely=20 for the individual or entity to which it is =20 addressed and may contain confidential and/or=20 privileged material. Any review, retransmission,=20 dissemination or other use of or taking action=20 in reliance upon this information by persons or=20 entities other than the intended recipient is=20 prohibited. If you have received this email in=20 error please contact the sender and delete the=20 material from any computer.=20
************************************************=20


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 17 2004 - 12:20:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US