Re: Please help my creating snapshot problem

From: Indra Harimurti <indra_at_sofrecom.co.id>
Date: Tue, 2 May 2000 16:00:36 +0700
Message-Id: <10485.104656@fatcity.com>

Joan,
Thanks for the reply, please confirm this if my group name is SNP_CORP and my
snapshot name is CORPORATE_DIV, the command would be :

begin
dbms_refresh.subtract('CORPORATE_DIV',

                                        'SNP_CORP',
                                        'CORPORATE_DIV',
                                        true);

end;
/

Please confirm. Thanks again ...

Indra

-----Original Message-----
From: Joan Hsieh <jhsieh_at_infonet.tufts.edu> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Monday, May 01, 2000 9:27 PM
Subject: 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)
> Encoding: base64

--
Author: Joan Hsieh
  INET: jhsieh_at_infonet.tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Tue May 02 2000 - 04:00:36 CDT