Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Please help my creating snapshot problem

Please help my creating snapshot problem

From: Indra Harimurti <indra_at_sofrecom.co.id>
Date: Mon, 1 May 2000 11:00:21 +0700
Message-Id: <10483.104527@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0079_01BFB35C.71FC8180
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



Dear List,



When I did :

create snapshot CORPORATE_DIV                                  =20
pctfree 10 initrans 2 maxtrans 255                             =20
storage ( initial 100k next  500k pctincrease 0 ) tablespace TS1
refresh fast next sysdate + 365                                =20
as select * from CORPORATE_at_DBL_DIVI;                           =20

this error appeared :
ERROR at line 5:                                                         =




    =20


ORA-23410: snapshot "OPS$GIRAFE"."CORPORATE_DIV" is already in a refresh =
group

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92                              =
    =20
ORA-06512: at "SYS.DBMS_IREFRESH", line 255                              =
    =20
ORA-06512: at "SYS.DBMS_IREFRESH", line 178                              =
    =20
ORA-06512: at "SYS.DBMS_REFRESH", line 97                                =
    =20
ORA-06512: at "SYS.DBMS_REFRESH", line 75                                =
    =20
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 39                              =
    =20
ORA-06512: at line 1         =20





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                                               =20








------=_NextPart_000_0079_01BFB35C.71FC8180
Content-Type: text/html;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

<HTML>

<HEAD>




<META content=3Dtext/html;charset=3Diso-8859-1 =

http-equiv=3DContent-Type>


<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>

</HEAD>

<BODY bgColor=3D#ffffff>

<DIV><FONT color=3D#000000 size=3D2>Dear List,</FONT></DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>When I did :</FONT></DIV>

<DIV><FONT size=3D2>create snapshot=20



CORPORATE_DIV&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>pctfree 10 initrans 2 maxtrans=20



255&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>storage ( initial 100k next&nbsp; 500k pctincrease 0 ) tablespace=20

TS1<BR>refresh fast next sysdate +=20


365&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>as select * from=20



CORPORATE_at_DBL_DIVI;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR></FONT></DIV>

<DIV><FONT size=3D2>this error appeared :</FONT></DIV>

<DIV><FONT size=3D2>ERROR at line=20


5:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=


sp;=20


<BR>ORA-23410: snapshot &quot;OPS$GIRAFE&quot;.&quot;CORPORATE_DIV&quot; =

is=20


already in a refresh group<BR>ORA-06512: at =
&quot;SYS.DBMS_SYS_ERROR&quot;, line=20


92&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>ORA-06512: at &quot;SYS.DBMS_IREFRESH&quot;, line=20

255&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>ORA-06512: at &quot;SYS.DBMS_IREFRESH&quot;, line=20

178&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>ORA-06512: at &quot;SYS.DBMS_REFRESH&quot;, line=20


97&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =





<BR>ORA-06512: at &quot;SYS.DBMS_REFRESH&quot;, line=20


75&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =





<BR>ORA-06512: at &quot;SYS.DBMS_ISNAPSHOT&quot;, line=20

39&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20


<BR>ORA-06512: at line=20



1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></DIV=
>


<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT size=3D2>the ORA 23410 tells me to Subtract the snapshot from =

the=20


current refresh group.</FONT></DIV>


<DIV><FONT size=3D2>I do not undestand &quot;refresh group&quot;, What =

command=20


should I use to get rid the</FONT></DIV>


<DIV><FONT size=3D2></FONT><FONT size=3D2>snapshot name from this =

refresh group ??=20


Please help, Thank you in advance.</FONT></DIV>


<DIV><FONT size=3D2></FONT><FONT size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT=20


size=3D2>Indra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=


bsp;=20


<BR></FONT></DIV>

<DIV><FONT size=3D2></FONT>&nbsp;</DIV>

Received on Sun Apr 30 2000 - 23:00:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US