List current schema (Oracle)

[phillipsp_acca]

Hi,

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

Regards,
Pat

[Yogeeraj_1]

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

[SteveKirby]

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).

[Alexander M. Ermes]

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

[phillipsp_acca]

Thanks guys ....