Re: dbms_snapshot.refresh - does it commit?
From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/05/31
Message-ID: <4omumq$4t3_at_nntpa.cb.att.com>#1/1
Date: 1996/05/31
Message-ID: <4omumq$4t3_at_nntpa.cb.att.com>#1/1
chuckh_at_dvol.com (Chuck Hamilton) wrote:
>Does the dbms_snapshot.refresh procedure automatically commit when
>finished?
>
Yes.
>Also, can you tell me where to find the actual source code for this
>procedure? The code in USER_SOURCE seems to be encrypted.
>--
Yes, it is encrypted.
Try this
select name, text from dba_source where NAME like '%DBMS_SNAPSHOT%'
and TYPE like '%PACKAGE%';
Naren Chintala
AT&T
naren_at_mink.att.com
Received on Fri May 31 1996 - 00:00:00 CEST