objects retrieval

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 - 02:11:36 CDT