Updatable views!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Updatable views!!

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    Updatable views!!

    Is there any way to find out whether a View is updatable or not i.e any DBA/ALL views to quickly get this info ?


  2. #2
    Join Date
    Jan 2004
    Posts
    162
    Yep.

    {DBA | ALL | USER}_UPDATABLE_COLUMNS

  3. #3
    Join Date
    Jul 2003
    Posts
    323
    Tx - mgd. to find that in the admin gde. my brains not functioning as it's Monday morning I guess.

    Something else:
    When I select owner from dba_views for a view I get 3 owners - what could be happening here ?



  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    3 people have a view with the same name

  5. #5
    Join Date
    Jul 2003
    Posts
    323
    Something tells me that this is not possible or am I forgetting something here too ?



  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    of course it is possible, different schemas can have objects with the same name

  7. #7
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Have you got developers working on/in their own schemas? Often happens.

  8. #8
    Join Date
    Jul 2003
    Posts
    323
    Yeah - since I was looking at prd. it kinda stumped me - looks like I gotta dig deeper into this db. !!


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