oracle sql and dba tutorial logo


Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step

Oracle SQL

Tutorial for Oracle SQL

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions

Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.

MySQL Tutorial

Learn MySQL step by step










Creating Oracle 12c Container Database Example

Creating a Container Database using DBCA

For Creating a Container Database using SQL Statements Please click here

Let’s us create a container database by name ICA and one pluggable database PDB1.

We will place all datafiles, logfiles,controlfile of CDB in /u02/oracle/ica directory and place seed database pdbseed database datafiles in ‘/u02/oracle/ica/pdbseed’ directory and pluggable database PDB1 files /u02/oracle/ica/pdb1 directory

Step 1: Make directories

$mkdir /u02/oracle/ica
$cd /u02/oracle/ica
$mkdir pdb1

Step 2. Start DBCA

Grant access to X-Windows by typing following command as root

#xhost +

Start DBCA as Oracle User

$ dbca

Choose "Create Database" option and click "Next" button

Oracle database details






Enter or edit the given options like Files Location, Administrative Password etc and click Next

Next Page



HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats

Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved