Re: Copy back-up data into an existing table

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 Received on Thu Feb 27 2003 - 21:58:10 CST