Saturday, July 13, 2019

Downloading Oracle 12c

Downloading Oracle 12c

Install and download Oracle 12c for learning Oracle database developer. It also supports PL/SQL.

Downloading Oracle SQL Developer

We need to download Oracle 12c database from oracle website this is the latest version of oracle currently
You can follow the given link to download that



Check on the Accept License Agreement and Click on the winx64_12201_database.zip  file, Signup with oracle to download and install the file

You need to unlock the HR account to access the tables in HR Schema. Schema contains list of tables, we do our practical on HR schema.
One of the Schema in Oracle SQL Developer is HR Schema. It contains many tables such as employees, departments, locations, etc. We need to unlock the HR schema because it is present in pluggable database. Let’s see what pluggable database means
Oracle 12c have Container Databases and Pluggable databases.

One Container Database have many pluggable databases. Pluggable database have many schemas. Schemas consists of many tables.


In fig 2.1 you can see one Container Database (CDB), many pluggable Databases (PDBs) present in container databases.


Our HR schema is present in one of the Pluggable database. So we need to enter into the Container Database (CDB) and then to Pluggable database just like changing the directories (From root Directory to Sub-directories)


0 comments:

Post a Comment

Global Certifications: