Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp table ( overright previous data )
sybrandb wrote:
> Not possible. An import is a series of INSERTS.
> If there is a PK on the table the INSERT will fail.
> If there is no PK on the table INSERT will create duplicates.
... and if you drop/truncate first, then import with ignore=y/n .... yada yada yayda ...
Basically we don't know what the OP wants to achieve. Received on Thu Dec 14 2006 - 06:10:50 CST