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

Home -> Community -> Usenet -> c.d.o.server -> Re: imp table ( overright previous data )

Re: imp table ( overright previous data )

From: gazzag <gareth_at_jamms.org>
Date: 14 Dec 2006 04:10:50 -0800
Message-ID: <1166098250.335079.59110@16g2000cwy.googlegroups.com>


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

Original text of this message

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