-
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
Vijay.s
-
Run:
DROP SNAPSHOT LOG ON TESTVIEW;
-
DROP SNAPSHOT LOG ON TESTVIEW
i m getting the following error
ORA-12002: there is no snapshot log on table
Vijay.s
-
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
-
How do i do that aarroyob ?
Vijay.s
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|