"Christophe" <christophe.cavelier_at_template-software.fr> wrote in message
news:qlJO7.15$G02.20392_at_monolith.news.easynet.net...
> Hi,
>
> I'm a beginer with Oracle and i have the following problem.
>
> I use a development tool which make a request for retrieving all available
> oracle table.
> Oracle don't accept this request (Error ORA-01039) when i use 'system'
user
> for example (dba user) but accept only with 'internal' user.
> I have this problem with Oracle 8.1.7 only (with Oracle 8.0.5, it work !).
> The request is :
> SELECT DISTINCT TABLE_NAME FROM ALL_CATALOG WHERE OWNER=USER OR (
> OWNER='PUBLIC' AND TABLE_NAME NOT IN ( SELECT SYNONYM_NAME FROM
ALL_SYNONYMS
> WHERE TABLE_OWNER = 'SYS' OR TABLE_OWNER = 'SYSTEM'))
This works fine under 8.1.7 for me. Internal is of course connecting as
sysdba. Is the database in a special state? not up or startup restricted or
some such?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Dec 03 2001 - 06:32:56 CST
