Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Unable to create View

    Need Help.......

    Here we have 2 users named as Allen and Joy created in the database with dba privilages. Here we want to create an view in Allen while taking table from Joy say(joy.prod). Here prod is table name of joy. when i give following command

    SQL>Create view John as select * from joy.prod;

    it gives following error,

    Create view John as select * from joy.prod
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    While We write only

    select * from joy.prod;

    it works well and shows contents of Prod table.

    Can anybody help us out to know what is the cause of the above problem and how to create the view as mentioned above. Immediate response shall be appriciable

    Thnaks in advance.
    Raj

  2. #2
    Join Date
    Oct 2003
    Posts
    71
    Its a privilege issue

    check this link http://www.dbforums.com/t971165.html

  3. #3
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120

    Re: Unable to create View

    Originally posted by Rajesh1803
    Need Help.......

    Here we have 2 users named as Allen and Joy created in the database with dba privilages. Here we want to create an view in Allen while taking table from Joy say(joy.prod). Here prod is table name of joy. when i give following command

    SQL>Create view John as select * from joy.prod;

    it gives following error,

    Create view John as select * from joy.prod
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    While We write only

    select * from joy.prod;

    it works well and shows contents of Prod table.

    Can anybody help us out to know what is the cause of the above problem and how to create the view as mentioned above. Immediate response shall be appriciable

    Thnaks in advance.
    Raj
    What schema is this view being created in??? You must also have the select privs on the tables used to create the view.
    If you want to be able to see it from any user you must create it in the public schema.
    Otherwise only the schema owner and those granted privs will be able to see this view.

Posting Permissions

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