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

Home -> Community -> Usenet -> c.d.o.server -> ORA-23308 while DROP_SNAPSHOT_REPOBJECT

ORA-23308 while DROP_SNAPSHOT_REPOBJECT

From: Jan Vondrak <jan.vondrak_at_globe.cz>
Date: Tue, 16 Oct 2001 07:25:50 +0200
Message-ID: <20011016072550.02fa7df2.jan.vondrak@globe.cz>


Hello,
do somebody know how to drop snapshot. If I run procedure DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT, it ends with ORA-23308. I'm totally on the end.

snapadmin_at_ihneds>BEGIN
DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT (
sname => 'SUPER',
oname => 'ARTICLES',
type => 'SNAPSHOT',
drop_objects => TRUE);
END;
/
  2 3 4 5 6 7 8 BEGIN *
ERROR at line 1:

ORA-23308: object SUPER.ARTICLES does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2484
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1684
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 126
ORA-06512: at "SYS.DBMS_REPCAT", line 1107
ORA-06512: at line 2


Elapsed: 00:00:00.00

But it exists:
snapadmin_at_ihneds>select count(*) from super.articles;

  COUNT(*)


    321192

I have dropped a lot of snapshots but only this make me problems...

Thank you for any idea,

-- 
Jan Vondrak - PHP Programmer, Oracle DBA
Globe Internet s.r.o.; http://globe.cz
Tel: ++420 2 3536-5000; Fax: ++420 2 3536-5009
Office: Planickova 1 CZ-162 00 Praha 6
Map: http://mapa.globe.cz
Received on Tue Oct 16 2001 - 00:25:50 CDT

Original text of this message

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