How to get the list of schemas in database
585697Sep 7 2008 — edited Sep 8 2008Hi 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