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:

• SESSION ID:(5.299) 1999.11.29.12.28.22.000
• 1999.11.29.12.28.22.000 ORA-12012: error on auto execute of job 25 ORA-12008: error in snapshot refresh path ORA-02266: unique/primary keys in table referenced by enabled foreign keys ORA-06512: at "SYS.DBMS_SNAPSHOT", line 271 ORA-06512: at "SYS.DBMS_IREFRESH", line 416 ORA-06512: at "SYS.DBMS_REFRESH", line 171 ORA-06512: at line 1

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 email