Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy back-up data into an existing table

Re: Copy back-up data into an existing table

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Fri, 28 Feb 2003 22:31:06 GMT
Message-ID: <3E5FE6CC.9020500@adelphia.net>


C Chang wrote:

> Alistair Thomson wrote:
> 

>>Hi
>>
>>Yes you can do this but you need to use the flag ignore=y (this tells the
>>import to ignore the create table error - as it already exists - and
>>continue loading the data). Watch out for any constraint violations eg
>>primary key etc.
>>
>>Incidentally, the rows=y flag means import or export the data contained in
>>the table. rows=no just exports the table definitions.
>>
>>Alistair
>>
>>"C Chang" <cschang_at_maxinter.net> wrote in message
>>news:3E5D94A7.5729_at_maxinter.net...
>>
>>>Because of limitation of our current HD, I plan to dump out data from a
>>>table and let the new data insert. Later when we need the old data, I
>>>will import those data back to the table and appending to existing
>>>data. Can I use the COPY to do this or just use the ROWS=y in imp
>>>syntax? Never done this. Need help. Thanks ahead.
>>>
>>>C Chang
>>
> Alistair:
>     Thanks.  I got this answer fro AskTome site and is trying now.  But
> according to the example from Tom, I will end up with duplicated rows of
> records.  For example, After i export the data out of the table, I
> removed some of data before a certain date and let the table keep
> growing with new ones. So when I import again, I will have some overlap
> data ( from when I export to that date ).  I am looking a solution to
> remove one of the duplicated ones and keep only one left.  Have any
> suggestions? appreciate again.
> 
> C Chang

Don't you have a PRIMARY KEY on the tables?

Aaaaaargh! Another file-based database implemented in ORACLE!

Please, for your sake, take a Relational DB class.

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost
Received on Fri Feb 28 2003 - 16:31:06 CST

Original text of this message

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