Re: objects retrieval

The closest data dictionary object to this in Oracle is dba_objects:

  select object_type, object_name from dba_objects where owner = <schema>;

  OBJECT_TYPE OBJECT_NAME

• ------------------- TABLE MY_TAB INDEX MY_INDX etc.

Paul Chang wrote:

> Hi,
>
> I am new to Oracle.
> We have a third-party script to install db objects into one oracle tablespace in
> one user schema.
> Scripts contain table/stored proc/trigger/rule/constraints/...
>
> How can I get the list of objects installed?
>
> in sybase:
>
> select * from sysobjects where type = "U" or type = "TR" or type = ....
>
> How I can do in Oracle?
>
> thanks,
>
> Paul.
Received on Mon Oct 12 1998 - 21:06:04 CDT