RE: Saving a group of tables on a database refresh
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2004 13:55:47 -0500
Michael
Forgive me if I misunderstood your original requirement. Do you mean that
you will be dropping all the other tables and relying on import to recreate
them? If that is true, this method will probably work for you.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kline.Michael
Sent: Tuesday, August 17, 2004 1:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Saving a group of tables on a database refresh
Seems to work.
SQL> create table mytst as select * from dual;
Table created.
SQL> select * from mytst;
D
-
X
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 -
Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
PFTST:/u001/app/oracle/admin/PFTST/exp>
PFTST:/u001/app/oracle/admin/PFTST/exp> exp /
Export: Release 8.1.7.4.0 - Production on Tue Aug 17 13:46:26 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
Enter array fetch buffer size: 4096 >
Export file: expdat.dmp > tst.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > t
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
character set
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > mytst
. . exporting table MYTST 1 rows
exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
PFTST:/u001/app/oracle/admin/PFTST/exp>
PFTST:/u001/app/oracle/admin/PFTST/exp> cat tst.par
log=tst.log
file=tst.dmp
full=y
ignore=n
commit=y
PFTST:/u001/app/oracle/admin/PFTST/exp> imp / parfile=tst.par
Import: Release 8.1.7.4.0 - Production on Tue Aug 17 13:48:04 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
character set
. importing OPS$ORACLE's objects into OPS$ORACLE
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "MYTST" ("DUMMY" VARCHAR2(1)) PCTFREE 10 PCTUSED 40
INITRANS "
"1 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 65536 NEXT 5242880 MINEXTENTS
1 MA"
"XEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL"
" DEFAULT) "
Import terminated successfully with warnings.
PFTST:/u001/app/oracle/admin/PFTST/exp>
PFTST:/u001/app/oracle/admin/PFTST/exp> sqlplus /
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Aug 17 13:48:40 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL> select * from mytst;
D
-
X
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 -
Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
PFTST:/u001/app/oracle/admin/PFTST/exp>
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
> Of Mercadante, Thomas F
> Sent: Tuesday, August 17, 2004 1:23 PM
> To: 'oracle-l@xxxxxxxxxxxxx'
> Subject: RE: Saving a group of tables on a database refresh
>
> 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
> -----------------------------------------------------------------
************************************************
The information transmitted is intended solely
for the individual or entity to which it is
addressed and may contain confidential and/or
privileged material. Any review, retransmission,
dissemination or other use of or taking action
in reliance upon this information by persons or
entities other than the intended recipient is
prohibited. If you have received this email in
error please contact the sender and delete the
material from any computer.
************************************************
----------------------------------------------------------------
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:
