• CASE STUDY (Loading Data from MS-ACCESS to Oracle)
• CASE STUDY (Loading Data from Fixed Length file into Oracle)
• CASE STUDY (Loading Data from MySQL to Oracle)
• Loading Data into Multiple Tables using WHEN condition
• Conventional Path Load and Direct Path Load
• Direct Path
• Restrictions on Using Direct Path Loads

Export and Import

• Invoking Export and Import
• Command Line Parameters of Export tool
• Example of Exporting Full Database
• Example of Exporting Schemas
• Exporting Individual Tables
• Exporting Consistent Image of the tables

Using Import Utility

• Example Importing Individual Tables
• Example, Importing Tables of One User account into another User account
• Example Importing Tables Using Pattern Matching

Migrating a Database across platforms

Data Pump Utility

• Using Data Pump Export Utility
• Example of Exporting a Full Database
• Example of Exporting a Schema
• Exporting Individual Tables using Data Pump Export
• Excluding and Including Objects during Export
• Using Query to Filter Rows during Export
• Suspending and Resuming Export Jobs (Attaching and Re-Attaching to the Jobs)

Data Pump Import Utility

• Importing Full Dump File
• Importing Objects of One Schema to another Schema
• Loading Objects of one Tablespace to another Tablespace
• Generating SQL File containing DDL commands using Data Pump Import
• Importing objects of only a Particular Schema
• Importing Only Particular Tables
• Running Import Utility in Interactive Mode

Flash Back Features

• Flashback Query
• Using Flashback Version Query
• Using Flashback Table to return Table to Past States
• Purging Objects from Recycle Bin
• Flashback Drop of Multiple Objects With the Same Original Name
• Flashback Database: Alternative to Point-In-Time Recovery
• Enabling Flash Back Database
• To how much size we should set the flash recovery area
• How far you can flashback database
• Example: Flashing Back Database to a point in time

Flashback Data Archive (Oracle Total Recall)

• Introduction
• Creating Flashback Data Archive tablespace
• Creating Flashback Data Archive
• Querying historical data

Log Miner

• LogMiner Configuration
• LogMiner Dictionary Options
• Using the Online Catalog
• Extracting a LogMiner Dictionary to the Redo Log Files
• Extracting the LogMiner Dictionary to a Flat File
• Redo Log File Options
• Example: Finding All Modifications in the Current Redo Log File
• Example : Mining Redo Log Files in a Given Time Range

Backup and Recovery

• Opening the Database in Archivelog Mode
• Bringing the Database again in NoArchiveLog mode
• Taking Offline (COLD) Backups
• Taking Online (HOT) Backups
• Recovering from the Loss of a Datafile
When the Database is running in Noarchivelog Mode When the Database is running in Archivelog Mode
• Recovering from loss of Control File

Recovery Manager ( RMAN )

• Taking Offline Backups using RMAN
• Recovering the Database running in NOARCHIVELOG mode using RMAN
• Taking Online Backups using RMAN
• Taking backups of particular tablespaces or datafiles using RMAN
• How to take Image Backups in RMAN
• Taking Incremental Backup using RMAN
• Incrementally updating backup copy for fast recovery
• View information about RMAN backups
• Configuring Retention policy in Oracle RMAN
• Configure various Options in RMAN
• Maintaining RMAN Repository
• Recovering from the loss of datafiles using RMAN (Archivelog mode)
• Recovering from the loss of datafile by changing it's location
• Performing Disaster Recovery using RMAN