Home » RDBMS Server » Server Utilities » import & Update
import & Update [message #68944] Mon, 01 October 2001 22:06 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: export after export
Next Topic: SQL*Plus
Goto Forum:
  


Current Time: Thu Mar 28 05:41:45 CDT 2024