-
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
-
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
-
Forum Rules
|
|