CODEWITHSUNDEEP
oracle-databaseplsqloracle12c
Poorna Reddy
Poorna Reddy

Reputation: 1

How to access EMP table in Oracle 12c?

I installed Oracle 12c on Windows Server 2008, installation went with no errors. After that I opened an SQL prompt, I don't see EMP nor DEPT tables (EMP and DEPT schemas should come by default, right?).

Could anyone can reply?

Upvotes: 0

Views: 1843

Answers (1)

Joe
Joe

Reputation: 3347

When you create an Oracle database, either at the time the software is installed, or later using the DBCA utility, there is an option to install the Sample Schemas. This is de-selected by default - you must explicitly enable this at the time of database creation.

To install the sample schemas after the database is installed, got to ORACLE_HOME/demo/schema to find the schemas.

Note: the accounts will be locked and you will need to unlock them, for example here.

Upvotes: 2

Related Questions