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

Thread: Updatable views!!

  1. 03-07-2005, 12:15 PM #1
    cruser3
    cruser3 is offline Senior Member
    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 ?

    Reply With Quote Reply With Quote
  2. 03-07-2005, 12:20 PM #2
    padders
    padders is offline Member
    Join Date
    Jan 2004
    Posts
    162
    Yep.

    {DBA | ALL | USER}_UPDATABLE_COLUMNS
    Reply With Quote Reply With Quote
  3. 03-07-2005, 12:25 PM #3
    cruser3
    cruser3 is offline Senior Member
    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 ?


    Reply With Quote Reply With Quote
  4. 03-07-2005, 12:26 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    3 people have a view with the same name
    Reply With Quote Reply With Quote
  5. 03-07-2005, 12:39 PM #5
    cruser3
    cruser3 is offline Senior Member
    Join Date
    Jul 2003
    Posts
    323
    Something tells me that this is not possible or am I forgetting something here too ?


    Reply With Quote Reply With Quote
  6. 03-07-2005, 12:52 PM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    of course it is possible, different schemas can have objects with the same name
    Reply With Quote Reply With Quote
  7. 03-07-2005, 01:01 PM #7
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Have you got developers working on/in their own schemas? Often happens.
    Reply With Quote Reply With Quote
  8. 03-07-2005, 03:29 PM #8
    cruser3
    cruser3 is offline Senior Member
    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. !!

    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