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: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 17 Aug 2004 13:55:47 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE6F6@EXCHMN3> 





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


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kline.Michael
Sent: Tuesday, August 17, 2004 1:07 PM


To: oracle-l_at_freelists.org


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_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
-----------------------------------------------------------------
----------------------------------------------------------------
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:56:35 CDT












Original text of this message













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