Snapshot

[vbaskar]

Hi All

i VE TRIED dropping a user

DROP USER TESTUSER CASCADE;

I ve got the following Error ::

ORA-00604: error occurred at recursive SQL level 1
ORA-12083: must use DROP MATERIALIZED VIEW to drop "TESTUSER"."TESTVIEW"

then i ve tried

DROP MATERIALIZED VIEW TESTVIEW;

The following error has occurred:

ORA-12003: snapshot "TESTUSER"."TESTVIEW" does not exist


i ve created materlized view as

CREATE SNAPSHOT TESTVIEW
AS
(
SELECT COL1,COL2,COL3.....FROM MYTABLE
)

Now..how do i drop ?

Rgds

[julian]

Run:

DROP SNAPSHOT LOG ON TESTVIEW;

[vbaskar]

DROP SNAPSHOT LOG ON TESTVIEW

i m getting the following error

ORA-12002: there is no snapshot log on table

[aarroyob]

Probably this snapshot is in arefresh group. You shall to leave out from this refresh group and after you will be able to drop it.

Hope that helps

Angel

[vbaskar]

How do i do that aarroyob ?

[aarroyob]

execute dbms_refresh.subtract('group_name','object_name);
But I think you will have the same problem with other objects in the refresh group.

Hope that helps