can't USE database in Oracle 11g

Question

I created a new database in oracle 11g using DBCA . I checked the listener in cmd -> lsnrctl and its running . with this command:
select instance_name, status from v$instance; I get my database name and it's status is OPEN
is there anything missing ? anything else I should check?
because when I put in use databasename; I get an error Unknown command use databasename !

USE is not a valid Oracle SQL command. You just need to connect to the database. — user330315
– user330315, Commented Dec 5, 2011 at 18:08
@a_horse_with_no_name thank you but what about show tables? I created a table and it was created successfully , desc tablename also works and descripes it but show tables fails? where can I get a list of valid Oracle SQL commands? — Katia
– Katia, Commented Dec 5, 2011 at 18:24
"where can I get a list of valid Oracle SQL commands?": from the manual: docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm for SQL and: docs.oracle.com/cd/E11882_01/server.112/e16604/toc.htm for SQL*Plus — user330315
– user330315, Commented Dec 5, 2011 at 18:53

Rajesh Chamarthi · Accepted Answer · 2011-12-05 23:09:19Z

1

As others have pointed out, USE is a SQL Server command. in Oracle, you can do one of the following, based on your scenario.

If you are working in an interactive mode (in unix.. for example), you can issue

sqlplus schema_name/password@database_name

to connect to the database and then issue your queries.

Please note that Databases in SQL server are equivalent to Schemas in Oracle. In oracle, you'll have one database and multiple schemas to logically differentiate different subject areas.

answered Dec 5, 2011 at 23:09

Rajesh Chamarthi

18.9k4 gold badges43 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

can't USE database in Oracle 11g

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related