Re: Import table

"Fleury" <christelle.fleury_at_waterair-industries.fr> wrote in message news:3cdb9a28$0$11115$626a54ce_at_news.free.fr...
> Hello,
>
> I make backup of Oracle database with export tool.
> Now if I want to import one table of database, I have some problems:
> - 0 records of table are imported and errors occured.
>
> To resolve the errors' problem, I put the parameter CONSTRAINTS=No and
> IGNORE=Yes.
> Is it possible to update a table with import tool ?
> ( This means the import tool have to update the existing record and insert
> not existing records ).
> ( Maybe I have to drop the table and import data, but I will loose the
data
> of one day !)
>
> --
>
>
> Salutations
>
> Christelle Fleury
>
> mailto:christelle.fleury_at_waterair-industries.fr
>
>
>
>
>

Is it possible to update a table with import tool ?

No, the import is nothing more than a series of inserts. How would it be otherwise given the import is intended as a logical backup.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address