Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to get the list of schemas in database

585697Sep 7 2008 — edited Sep 8 2008
Hi All,

I have installed 2 Oracle instances on single machine. Earlier I have problems in logging into the system as database was getting confused with 2 oracel sids. However, I have manually set ORACLE_HOME and ORACLE_SID on DOS prompt.

Now I want to access a table of some schema. I am sure that I am specifying the name of schema in sql query. However, it says that table or schema does not exist.

I want to see the list of available schemas.

Could any body please help me in this?

Help would be appreciated greatly!

Regards,
Abdul

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 6 2008
Added on Sep 7 2008
6 comments
4,368 views