snapshot

Hi all,

I am having problem delete a view created by snapshot.
The snapshot was created on Oracle 8.1.6 and master database is 7.3.4.

Here is what I did:

1) create a snapshot as user A
SQL > Create snapshot emp
refresh complete with rowid
start with sysdate next sydate + (1/24)/12
as select * from emp@database_link;

2) Then I found out I should not use emp as the name of the view, so I renamed it to new_emp as user A.

3) I removed the snapshot as user DBA.
I verify by querying dba_snapshot, no row selected.

4) However, the table new_emp is still under user A's schema. I try to remove it
SQL> drop table new_emp
get error:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "new_emp".

So I tried
SQL > drop materialized view new_emp;
get error:
ORA-12003: snapshot "new_emp" does not exist.

I tried to remove it under both user A or DBA, but not work.

How can I remove new_emp?

Thank you.