Rman Backup In Multitenant Database Oracle 12c

Introduction: –   As a DBA we all familiar with the backup commands. In the latest database of Oracle,  we find some different commands we must keep it in mind how to take backup. In this article, we are going to know about the  Rman Backup In Multitenant Database Oracle 12c.With multitenant feature introduced in oracle 12c, […]

Read More

Views_as_tables Parameter In Datapump Of Oracle 12c

VIEWS_AS_TABLES parameter has been introduced in datapump of 12c. With this, we can export a view from a source database and import as a table in a target database. Create a view:

  Take export of this view as a table using views_as_tables parameter:

Now drop the view and import the same from the […]

Read More

LOGTIME=ALL Parameter In Datapump Of Oracle 12c

Introduction: –  As Oracle user, we are learning Oracle export/import from 9i still changes are going on. 12c has introduced LOGTIME=ALL Parameter In Datapump. We are going to know about LOGTIME=ALL Parameter In Datapump in 12c. Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file […]

Read More

Common User Vs Local User In 12c Multitenant

Introduction: –Database users are the one who really uses and takes the benefits of the database. There will be different types of users depending on their need and way of accessing the database. Application Programmers – They are the developers who concur with the database by means of DML queries. These DML queries are written in […]

Read More

How To Setup Listener For PDBS In Multitenant Database.

Introduction: – We all know that The Oracle Listener is a process listening for incoming database connections. This process is only needed on the database server side. The listener is controlled via the lsnrctl utility. Configuration is done via the listener.ora file.In this article, we are going to setup listener for PDBS in Multitenant Database. If you wish to setup […]

Read More

IN-MEMORY In Oracle 12c

Introduction :- Oracle 12c has lots of characteristics  In-Memory is one of the most important features.  It enables tables, partitions, materialized views be stored in memory using column format, which delivers fast SQL processing for the Analytical purpose. Oracle Database In-Memory proffers an idiosyncratic dual-format architecture that legalizes tables to be concurrently represented in memory using standard row […]

Read More

Truncate table with cascade feature1 in oracle 12c

In oracle 12c TRUNCATE TABLE CASCADE will truncate its child tables, if ON DELETE CASCADE relationship is present on child table. Create one parent and child table with some data

You can check the child table details using : Get child table details

Truncate the parent table with cascade option:

We can […]

Read More

Row limiting clause in oracle 12c

Row limiting clause clause allows sql queries to limit the number of rows returned and to specify a starting row for the return set. 1. Fetch first N rows:

2. Fetch 5 rows after offset of 4 rows

3. Fetch percentage of rows from a query:

Read More

Move tables (online / offline) in Oracle (9i-12cR2)

I must thank my fellow DBA Franky Weber Faust for his publication in his blog.  The goal here is to share the procedures for performing the move of tables in Oracle Database from version 9i to version 12cR2. Here in this article I am using 12cR2 ( to also be able to demonstrate the features […]

Read More