Duration : 1.5 Months
Fees : 15,000 /-
- 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