Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: knowing the tables in the user account / schema?

Re: knowing the tables in the user account / schema?

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 07 Feb 2002 20:07:01 GMT
Message-ID: <3C62DE69.38BE6DFB@ci.seattle.wa.us>


I doubt it is ... but you answer wouldn't solve the problem. You must look in DBA_ or ALL_ to answer the question.

If you had 100 schemas in an instance you would need to log on 100 times and check user_objects to figure out what was where.

Daniel Morgan

lif wrote:

> is it an hoax or a troll ?
>
> look at the table user_objects
>
> "DukeNM" <akshaysalkar_at_joymail.com> a écrit dans le message news:
> f987cd53.0202062331.6e87f95b_at_posting.google.com...
> > how to know what are the tables, view, etc. present for a specific
> > user if i am the dba.
Received on Thu Feb 07 2002 - 14:07:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US