Re: object retrieval

Paul, you can try select * from user_objects.

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> ..
>
> 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 Fri Oct 16 1998 - 18:43:12 CDT