Results 1 to 2 of 2

Thread: using a synonym in a view

  1. #1
    Join Date
    Nov 2002
    Posts
    1

    using a synonym in a view

    Hi!:
    I'm a very, very nee to oracle and
    i have the following problem:

    1. due tablespaces
    2. I've created a public synonym for
    tablespace1.table1

    3. login to oracle as user xx
    I can do:
    select * from my_synonym;

    4. when i try to create a view
    using the synonym I've got:

    ORA-00942: the table or view
    doesn't exists.

    Any hint ?
    (may be a privilege problem?)


    Best Regards

    Francisco



  2. #2
    Join Date
    Nov 2002
    Posts
    19
    Dear Fransisco,

    Cause Action
    ORA–00942 table or view does not exist
    The table or view entered does not exist, a synonym that is not allowed here
    was used, or a view was referenced where a table is required. Existing user
    tables and views can be listed by querying the data dictionary. Certain
    privileges may be required to access the table. If an application returned this
    message, the table the application tried to access does not exist in the database,
    or the application does not have access to it.
    For Trusted Oracle7 configured in DBMS MAC mode, you may get this
    message if you attempt to access an object that you do not dominate.
    Check each of the following:
    the spelling of the table or view name.
    that a view is not specified where a table is required.
    that an existing table or view name exists. Contact the database
    administrator if the table needs to be created or if user or application
    privileges are required to access the table.
    Also, if attempting to access a table or view in another schema, make certain
    the correct schema is referenced and that access to the object is granted.
    For Trusted Oracle7 in DMBS MAC mode, if the cause is an object existing at a
    higher label, alter your current label to dominate the creation label of the object.

    Then retry the command.

    ashdiip

Posting Permissions

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