Re: imp table ( overright previous data )

From: sybrandb <sybrandb_at_gmail.com>
Date: 14 Dec 2006 04:06:34 -0800
Message-ID: <1166097994.572664.43920@16g2000cwy.googlegroups.com>

On Dec 14, 12:11 pm, "peter" <hhh.datab..._at_gmail.com> wrote:
> hi all,
> is it possible the data which is in export dump file, overright the
> data of database which importing.

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.

It strikes me you are asking such elementary questions, which could be addressed by reading the documentation. Are you just lazy, or do you intend to misuse this group as a free Oracle course?

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Dec 14 2006 - 06:06:34 CST