-
Hi,
I want to drop a user, (with the CASCADE clause), but it says that i should first drop one materialized view. But when i try to drop it it says there is no such materizlized view/snapshot. It gives the snapshot in listings of tables, and when i try it to drop it as a table it says it should be dropped using DROP MATERIALIZED VIEW. So how do i drop this M VIEW? so i can drop the user?
Thanx!
-
Use drop materilaized view viewname;
that's enough.
if you a session of the user then u cannot drop him.
check that also.
Radhakrishnan.M
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
|