RE: Saving a group of tables on a database refresh

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 17 Aug 2004 11:13:37 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8508E55@okcexg3.kmg.com>

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

We have a request to not blow off or change all tables that start with "OPB_".
=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
-----------------------------------------------------------------

Received on Tue Aug 17 2004 - 11:10:33 CDT