Determine if Schema exists

newP

Hi,
I have to programmatically determine if Oracle Schema (Database) exists. Is there any query I can use for that?

e.g. in SQLSERVER 'Use myDB' would work and give me an error if myDB doesn't exists, I want to find something like that for Oracle.

Thanks for help,
NewP

debasisdas

Do you want to check for Schema or Database ?

Because both are different from each other in oracle

newP

I guess, DataBase. e.g. If I want to select records from a table, I would write,

Select * from DBNAME.TABLENAME;

This query would fail for number of reasons; two of them are
1. DBNAME doesn't exist
2. TABLENAME doesn't exist.

I want to know if DBNAME exists before writing such a query.

Thanks,
NewP

newP

One solution that comes in my mind is ---

to try creating a table in the database

CREATE TABLE DBNAME.TBL1((col1 integer, col2 varchar2(20));

and this query returns error 'user DBNAME doesn't exists', if DBNAME doesn't exists.

But is there any straightforward way to know the same thing?

Thanks
NewP

Saii

SELECT username FROM dba_users

This will show current users on database.

newP

Thank you : That works for me

NewP

Determine if Schema exists

re: Determine if Schema exists

re: Determine if Schema exists

re: Determine if Schema exists

re: Determine if Schema exists

re: Determine if Schema exists

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about