I want to create a PL/SQL procedure that takes about 30 Oracle database
tables and copies them to a remote server. However, I'm not sure how
to deal with certain referential integrity issues. One issue is that
the database may be getting updated while the copy is being performed.
Another issue is that, even if the database isn't being updated, at
times during the copy, constraints may be violated.
So do I have to basically disable each constraint individually and
exclusively lock all the tables? Or is there an easier way?
Received on Wed Aug 09 2006 - 15:00:14 CDT
