Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

List current schema (Oracle)

Occasional Advisor

List current schema (Oracle)


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

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

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

Re: List current schema (Oracle)

Thanks guys ....