hi all,
is it possible the data which is in export dump file, overright the
data of database which importing.

peter wrote:
> hi all,
> is it possible the data which is in export dump file, overright the
> data of database which importing.

Yes or no, depending on what you are trying to achieve.

If you tell us what you actually want to do, we can be of more help.

HTH

-g

On Dec 14, 12:11 pm, "peter" <hhh.datab...@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

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.