Bill,
Where are you trying to load the data to? Do the tables already exist? If
so, then use the ignore=y option and it won't complain if the table already
exists when it tries to create it, but it will load the data into it.
Bill Conner wrote:
> Hi All,
>
> i am starting to feel real dum
I assume that the schemas, tables, synonyms, roles, grants, etc already
exist and you just want to populate the tables with the data from your
other database.
In your parm file set IGNORE=Y. This will ignore errors caused by already
created objects and just load the data.
Type: imp help=y
to
Bill
Ignore=Y is that what you're looking for?
Mike
-Original Message-
Sent: Friday, August 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Hi All,
i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp
3
times but don't seem able to get the imp to just
Bill,
I assume from the way you state this, you already have the tables built and
don't want imp to blow up trying to recreate them. Correct? If so, try
ignore=y. Also, if the user is changing, are you using "fromuser= touser="?
Output from your problem might be helpful.
HtH,
John P Weatherm
