import & Update [message #68944] |
Mon, 01 October 2001 22:06 |
Asique Ahamed
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
I want to import a list of tables from a schema and insert into another schema. If I user export/import option, I have a limitation. If i get Unique constraint error while importing it hits an error.
I can give an option IGNORE = Y.
But I want the record to be updated and not skip.
Can u guys throw some light on this issue
----------------------------------------------------------------------
|
|
|
Re: import & Update [message #68959 is a reply to message #68944] |
Thu, 04 October 2001 07:24 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
create instead of triggers in the target schema .
(normally triggers are not recommended while import becoz of the time consumption..)
but I guess it would solve your problem
so u have to decide whether you can bear with the time. (I mean its okay if the objects are considerably small)
oraboy
----------------------------------------------------------------------
|
|
|