Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    184

    Unanswered: drop materialized view stalls

    I need to drop several materialized views inside an Oracle 9i database. Normally, this isn't a problem, but for this particular instance, when I execute the 'drop materialized view...;' command, the system starts execution, but never finishes and doesn't generate any errors. I've looked in the Oracle alert log for any hints but cannot find any errors.

    Any suggestions as to what/where to look next or ideas about what may be causing this would be greatly appreciated.

    Thank you.

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Have you looked in the v$ views to see what the session is waiting on and what it's status is?

  3. #3
    Join Date
    May 2004
    Posts
    184
    Buckeye,

    Thanks, that was it! There were several locked sessions. Thanks for pointing me in the correct direction.

    Regards.

Posting Permissions

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