-
Hi,
what could be the reason?
I want to select or describe the objects I can handle. So I try
>select * from all_objects;
"sp2-0561" is the answer.
Has anybody an anwer? I would be happy!
chris
-
the only possibility to select dba_objects, all_objects or user_objects ist to connect as "INTERNAL". Other users can not select this views! I granted SELECT ANY TABLE to differend users and repeated the procedure, nothing changed! I run catalog.sql, nothing changed!
Any help?
chris
-
Would you please provide your Oracle release? If it is 8.0 then it is a known bug....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Indeed it is Oracle Version 8.0.5.0.0 !
Are there any bug fixes?
Thank you for your advice!
chris
-
One of the possible workarounds would be not to use public synonyms in such cases. ALL_OBJECTS is a public synonym for a view SYS.ALL_OBJECTS.
So try to use full qualified names instead of synonyms, like:
SELECT * FROM SYS.ALL_SYNONYMS;
Hope it will work....
For bugfixes, search the Metalink or contact your Oracle Support.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|