ORA-12083 When Drop user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-12083 When Drop user

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Hi All,
    I encounter the error message when I tried to drop user cascade. The error code is ORA-12083 must use DROP MATERIALIZED VIEW to drop %s.%s

    After that I try to use DROP MATERIALIZED VIEW command to drop my Matarialized views. But it say the Materialized view is not found - ORA-12003 snapshot "mymaterialized" not found


    Your input is very much appreaciated.... TQ

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Search in this forum for this error. Sometime ago Julian did a solution for this.

    cheers

    Angel

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    This is the thread:

    http://www.dbasupport.com/forums/sho...threadid=22379

    Hope that helps

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width