Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

List current schema (Oracle)

phillipsp_acca
Occasional Advisor

List current schema (Oracle)

Hi,

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

Regards,
Pat
4 REPLIES
Yogeeraj_1
Honored Contributor

Re: List current schema (Oracle)

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
SteveKirby
Frequent Advisor

Re: List current schema (Oracle)

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
Honored Contributor

Re: List current schema (Oracle)

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
phillipsp_acca
Occasional Advisor

Re: List current schema (Oracle)

Thanks guys ....