RE: Saving a group of tables on a database refresh
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2004 13:23:13 -0400
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@xxxxxxx]
Sent: Tuesday, August 17, 2004 12:14 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kline.Michael
Sent: Tuesday, August 17, 2004 10:58 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx=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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
