Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ora imp
"MD" <md_at_md.com> wrote in message news:virJf.94163$4l5.71944_at_dukeread05...
> Hi,
> I'm running the imp on an existing schema on 9i and I get unique
constraint
> errors. What I want is to overwrite all data and not merge the data. Is
this
> a flag in the imp function or is this something in the exp function.
>
> Thanks,
> MarkD
>
>
You can truncate the current table and import into that. (replace the data
which exp/imp is designed for.)
You could rename the current table and import and then insert the
non-matching rows back in.
Jim
Received on Fri Feb 17 2006 - 18:19:20 CST