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!
|
|
|