Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Refreshing Snapshots with Foregn Key defined on them
I have snapshots with F/Kes defined on them.
so when they 'try' to refresh, they produce the following:
So I fugre the only way to do this 'automatically' is to write a PL/SQL procedure which would drop constraints, and then do DBMS_SNAPSHOT.REFRESH and then recreate constraints? And then put this into a DBMS_JOB?
Any other suggestions?
Also, will the data be anavailable while the snapshot is refreshing?
Thanx
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Mon Nov 29 1999 - 12:38:59 CST