USE DATABASE command on SQL PLUS ORACLE 11gr1

oracle oracle11g
laruffii picture laruffii · May 5, 2012 · Viewed 88.3k times · Source

After successfully installing ORACLE 11gR1 on Windows7 32bit platform, I can go inside the SQL PLUS and I can also create database, but I still don't have any clue how to use database.

in MySQL the command to use database should be:

USE MYDATBASENAME;

In SQL SERVER also quite the same:

USE [DATABASE];

But I have no idea how to use database in ORACLE 11gR1 via SQLPLUS, any body have any ideas?

I'm planning to create a table after I succeed in using the USE command.

Answer

a_horse_with_no_name picture a_horse_with_no_name · May 5, 2012

Even though they all use the same noun the term "database" is something completely different between MySQL (SQL Server) and Oracle.

Usually a MySQL database is mapped to a schema/user in Oracle. In Oracle there is a 1:1 relationship between schemas and users.

A "database" in Oracle refers to the complete installation (which is also named "instance"). As there is typically only a single instance/installation there is no sense in "switching a database" in Oracle.

The closest thing to "USE mydatabase" in Oracle would be to switch the current schema:

ALTER SESSION SET current_schema = other_user;

Then you can access all tables of other_user without prefixing them. This of course requires your current user to have at least select privileges on the tables of the other user (i.e schema)

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error …

Read More