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: object retrieval

Re: object retrieval

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 15 Oct 1998 21:14:05 GMT
Message-ID: <362a6568.32242602@dcsun4.us.oracle.com>


On 15 Oct 1998 20:49:42 GMT, pch_at_pinnacle. (Paul Chang) wrote:

>
>Hi,
>
>I am new to Oracle.
>
>If I, as regular db user not dba, want to access thur sqlplus, I need to know all db objects which belongs to me.
>
>SQL> ..
select OBJECT_NAME, OBJECT_TYPE from user_objects;

>
>what query I need to use from client side using sqlplus?
>
>I can only do this from svrmgrl from server side?
>
>thanks,
>
>Paul.
>
>
Received on Thu Oct 15 1998 - 16:14:05 CDT

Original text of this message

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