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
C Chang wrote:
> Alistair Thomson wrote: >
> 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 frostReceived on Fri Feb 28 2003 - 16:31:06 CST