Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
************************************************=20The 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
-- 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
![]() |
![]() |