topic Re: List current schema (Oracle) in Operating System - HP-UX

List current schema (Oracle)

phillipsp_acca — Fri, 30 Jun 2006 16:52:11 GMT

Hi,

Could anyone advise me what is required to list current schema's that are present.

Regards,
Pat

Re: List current schema (Oracle)

Yogeeraj_1 — Sat, 01 Jul 2006 03:50:18 GMT

hi Pat,

there are numerous ways to do this.

easiest way, if to run sqlplus and run the following sql statement:

select object_name, object_type
from user_objects

does this answer your question?

kind regards
yogeeraj

Re: List current schema (Oracle)

SteveKirby — Sun, 02 Jul 2006 21:53:50 GMT

I would first use Enterprise Manager. Install on your local PC and then just view "SCHEMA".

From the command-line the easiet I would use would be:
select distinct(owner) from dba_objects;

Note: That will only list users that have object in the system.

Another SQL you might use would be
select * from dba_users; (or select * from all_users).

Re: List current schema (Oracle)

Alexander M. Ermes — Mon, 03 Jul 2006 04:34:34 GMT

Hi there.
Depends on what you want to work with.
Either you are a console jockey with a built-in keyboard in your suit or you ar e one of these so called mousepushers.
1) console jockey --> try to go through sql statements. This URL might help :

http://www.quest-pipelines.com/pipelines/dba/

2) playing aroung with your mouse you should install the Oracle Enterprise Manager ( called OEM ) on your pc and start it standalone. You can also create a separate repository database for the OEM, where you can store your data.
Rgds
Alexander M. Ermes

Re: List current schema (Oracle)

phillipsp_acca — Mon, 03 Jul 2006 05:50:00 GMT

Thanks guys ....