Home » Server Options » Replication » can't drop snapshot
can't drop snapshot [message #75296] Thu, 12 December 2002 20:58
cmn
Messages: 19
Registered: March 2002
Junior Member
Hi!

I know little about replication.
When test snapshot between host1 and host2,I encounter problem as following.

platform: RedHat linux7.2
oracle817

on host1:
create database link test connect to username identified by password using 'orcl';
The database link works.

on host2:
create snapshot log on mytable;

on host1:
create snapshot m_mytable refresh complete start with sysdate next syssdate+1/(24*60) with primary key
as (select * from mytable@test);

The snapshot m_mytable works and refershes well.

But when I drop snapshot log on mytable on host2,then I can't drop snapshot m_mytable on host1.

On host2
drop snapshot log on mytable

On host1

SQL> drop snapshot m_mytable;
drop snapshot m_mytable
*
ERROR at line 1:
ORA-12003: snapshot "USER_TEST"."M_MYTABLE" does not exist

SQL> select object_type,status from user_objects where object_name='M_MYTABLE';

OBJECT_TYPE STATUS
------------------ -------
TABLE VALID

SQL> drop table m_mytable;
drop table m_mytable
*
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "USER_TEST"."M_MYTABLE"

SQL> DROP MATERIALIZED VIEW M_MYTABLE;
DROP MATERIALIZED VIEW M_MYTABLE
*
ERROR at line 1:
ORA-12003: snapshot "USER_TEST"."M_MYTABLE" does not exist

Why can't drop snapshot m_mytable while it does exist when query from data dictionary views.
Please give me some advice.
THANKS!
Previous Topic: Replication using triggers. Urgent!
Next Topic: How to Replicate DDL instructionts without resuming the Replication? is that possible?
Goto Forum:
  


Current Time: Thu Nov 26 04:47:29 CST 2020