Re: Please help my creating snapshot problem

Use dbms_refresh.subtract precedure to snapshot group ex:
begin

	dbms_refresh.subtrace(name => 'XXXX',(refresh group name)
			      list=> 'XXX','xxxx' (snapshot name),
                              lax => true); 

Joan

ORACLE-L_at_fatcity.com wrote:
>
> Dear List,
>
> When I did :
> create snapshot CORPORATE_DIV
> pctfree 10 initrans 2 maxtrans 255
> storage ( initial 100k next 500k pctincrease 0 ) tablespace TS1
> refresh fast next sysdate + 365
> as select * from CORPORATE_at_DBL_DIVI;
>
> this error appeared :
> ERROR at line 5:
> ORA-23410: snapshot "OPS$GIRAFE"."CORPORATE_DIV" is already in a refresh group
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92
> ORA-06512: at "SYS.DBMS_IREFRESH", line 255
> ORA-06512: at "SYS.DBMS_IREFRESH", line 178
> ORA-06512: at "SYS.DBMS_REFRESH", line 97
> ORA-06512: at "SYS.DBMS_REFRESH", line 75
> ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 39
> ORA-06512: at line 1
>
> the ORA 23410 tells me to Subtract the snapshot from the current refresh group.
> I do not undestand "refresh group", What command should I use to get rid the
> snapshot name from this refresh group ?? Please help, Thank you in advance.
>
> Indra
>
> ------------------------------------------------------------------------
> Name: attach1
> attach1 Type: unspecified type (application/octet-stream)
Received on Mon May 01 2000 - 08:18:24 CDT