Re: invalid objects questions

you can use dba_objects table, and status column to see if the object is valid or not.
don't need dba rights. use : grant select on dba_ojbects to username

you can use the dba_users table to check user infos

you can go to tahiti.oracle.com for docs

jh

"jim agans" <jwagans_at_yahoo.com> wrote in message news:82659da6.0301161809.162cdd36_at_posting.google.com...
> hello,
>
> I would like to find all the "invalid objects" in our test database. I
> assume there is a oracle system table that lists them? Do I need dba
> rights to see it?
> beacause Im not seeing any now. Also, How do I determine the number of
> schemas on this DB? Maybe there names and any info>??
> Any help will be greatly appreciated!!!!
> thanks
> jim
>
> jwagans_at_yahoo.com
Received on Fri Jan 17 2003 - 05:47:47 CET