Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy back-up data into an existing table
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
Received on Thu Feb 27 2003 - 08:17:09 CST