Re: error handling during import

On Mon, 22 Apr 2002 12:43:54 +0300, "George D. Benetos" <gbenet_at_intranet.gr> wrote:

>I have the following problem using importng utility
>when there is a unique constraint , then i get the follwing message ...
>
>if there are many duplicated errors then the log file has a very large size ....
>
>Is there any way that this error mesages are not displayed in the terminal ,
>and only the final message concerning the total number of rows inserted is displayed ???
>
>thanx .........

There isn't.
Apparently you have an aborted import and you are now importing this table for the second time.
To prevent these messages
you could have
- truncated the original table
- disabled or deferred the constraint, making sure the exceptions are being caught in an appropiate table when enabling the constraint.

From the 2 posts today, it appear you don't really know how Oracle works and can work, and you prefer to come up with rash proposals that only fight symptoms. Maintaining databases is not equivalent to just hitting the button and see what happens.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 22 2002 - 13:33:52 CDT