Виж, не съм се занимавал със репликация, но ти поствам, това което открих по твоя проблем. Не знам дали ще помогне, но го прочети:

----------------------
Problem Description
-------------------

When you issue the following command to drop a table, you receive an ORA-12083,
indicating that there is a materialized view. For example:

SQL> drop table account_ref_x;
drop table account_ref_x
*
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "DTMADMIN"."ACCOUNT_REF_X"

If you try to drop the materialized view, the error that the snapshot does not
exist is returned:

SQL> DROP MATERIALIZED VIEW account_ref_x;

DROP MATERIALIZED VIEW account_ref_x
*
ERROR at line1:
ORA-12003: snapshot "DTMADMIN"."ACCOUNT_REF_X" does not exist


Solution Description
--------------------

1. Determine which table the renamed snapshot was recreated from. If the base
table cannot be determined, then you must create a table with the same
columns.

2. Recreate the snapshot table:

SQL> create snapshot ACCOUNT_REF_X ON PREBUILT TABLE as select * from dept;
Materialized view created.

3. Drop the snapshot:

SQL> drop snapshot ACCOUNT_REF_X;
Materialized view dropped.

4. Drop the table:

SQL> drop table ACCOUNT_REF_X;
Table dropped.


Please Note:

In Oracle9i, it is not possible to rename a materialized view/snapshot:

SQL> rename account_ref_x to dept;
rename account_ref_x to dept
*
ERROR at line 1:
ORA-32318: cannot rename a materialized view


Explanation
-----------

Renaming a materialized view/snapshot is not mentioned in the documentation.
It is not prohibited when executed, but it should not be allowed.

SQL> create snapshot account_ref as select * from toto.dept;
Materialized view created.

SQL> rename account_ref to account_ref_x;
Table renamed.

SQL> drop snapshot ACCOUNT_REF;
Materialized view dropped.

SQL> drop snapshot account_ref_x;
drop snapshot account_ref_x
*
ERROR at line 1:
ORA-12003: snapshot "TOTO"."ACCOUNT_REF_X" does not exist

SQL> drop table account_ref_x;
drop table account_ref_x
*
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "TOTO"."ACCOUNT_REF_X"

----------------------