Re: ora imp

On 19 Feb 2006 00:18:37 -0800, "Stronfogg" <philmulhall_at_gmail.com> wrote:

>If using imp, use the parameter:
>
>ignore=Y
>
>this should ignore any errors (eg constraint violations) and continue
>processing the records.

ignore=Y only ignores object existence.
>
>Also, you may choose to 'bad' file parameter - this will record the
>records that violated the constraint into the indicated flat file which
>you can use for further processing.

Imp doesn't have a bad file parameter. You are confusing imp with sql*loader.

Could you please verify your advice is correct, prior to posting?

--
Sybrand Bakker, Senior Oracle DBA