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: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Tue, 17 Aug 2004 14:07:18 -0400
Message-ID: <52C70FF150F49E479DAF59C68A27149D11DC69@va016a0e2.corp.suntrust.com> 





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_at_freelists.org



[mailto:oracle-l-bounce_at_freelists.org] On Behalf


> Of Mercadante, Thomas F

> Sent: Tuesday, August 17, 2004 1:23 PM

> To: 'oracle-l_at_freelists.org'

> 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_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

> ----------------------------------------------------------------- 





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_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 - 13:03:12 CDT












Original text of this message













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