DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unable to drop view

  1. 05-06-2003, 09:47 PM #1
    chukkala
    chukkala is offline Junior Member
    Join Date
    Apr 2003
    Posts
    15

    Unable to drop view

    Hi

    I'm unable to drop a view owned by me. The system hangs when I issue 'DROP VIEW .

    In DBA_OBJECTS the STATUS shows 'VALID'. Is there any other places I need to check?

    Can you help to how to drop this problem.

    Thanks & Regards
    Bhaskara
    Reply With Quote Reply With Quote
  2. 05-06-2003, 10:47 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would check to see if anybody else has a lock on that view.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 05-07-2003, 12:09 AM #3
    chukkala
    chukkala is offline Junior Member
    Join Date
    Apr 2003
    Posts
    15
    Hi Thanks for your reply.

    Can you help me how to check.

    Is there any sql for that.

    Regards
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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