Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: object retrieval
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