2023 2024 Student Forum > Management Forum > Main Forum

 
  #2  
5th January 2016, 10:22 AM
Super Moderator
 
Join Date: May 2012
Re: Oracle DBA

Hello, here I am providing you the details of the Oracle DBA course offered by the oracle as under:

You will learn:
Oracle Database Administration Contents

Introduction to Oracle Database
Overview of Oracle Grid Architecture
Difference between a cluster and a grid
Responsibilities of Database Administrators

Creating Oracle Database
Creating Oracle 11g / 10g Database using SQL commands
Creating Oracle Container Database in 12c using DBCA
Creating Oracle Container Database in 12c using SQL commands

Managing Oracle 12c Container Databases
Creating User Accounts and Connecting to Oracle 12c Container and Pluggable Databases

Managing Pluggable Databases in Oracle 12c
Creating Pluggable Database from Seed
Cloning an Existing Pluggable Database
Unplugging and Plugging databases from one CDB to another CDB

Managing Tablespaces and Datafiles
Creating New Tablespaces
Bigfile Tablespaces (Introduced in Oracle Ver. 10g)
To Extend the Size of a tablespace
To decrease the size of a tablespace
Coalescing Tablespaces
Taking tablespaces Offline or Online
Making a Tablespace Read only.
Renaming Tablespaces
Dropping Tablespaces
Viewing Information about Tablespaces and Datafiles
Relocating or Renaming Datafiles
Renaming or Relocating Datafiles belonging to a Single Tablespace
Procedure for Renaming and Relocating Datafiles in Multiple Tablespaces

Temporary Tablespace
Increasing or Decreasing the size of a Temporary Tablespace
Tablespace Groups
Creating a Temporary Tablespace Group
Assigning a Tablespace Group as the Default Temporary Tablespace

Diagnosing and Repairing Locally Managed Tablespace Problems
Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)
Scenario 2: Dropping a Corrupted Segment
Scenario 3: Fixing Bitmap Where Overlap is Reported
Scenario 4: Correcting Media Corruption of Bitmap Blocks
Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed Tablespace

Transporting Tablespaces
Procedure for transporting tablespaces
Transporting Tablespace Example

Managing REDO LOGFILES
Adding a New Redo Logfile Group
Adding Members to an existing group
Dropping Members from a group
Dropping Logfile Group
Resizing Logfiles
Renaming or Relocating Logfiles
Clearing REDO LOGFILES
Viewing Information About Logfiles

Managing Control Files
Multiplexing Control File
Changing the Name of a Database
Creating A New Control File
Cloning an Oracle Database

Managing the UNDO TABLESPACE
Switching to Automatic Management of Undo Space
Calculating the Space Requirements for Undo Retention
Altering UNDO Tablespace
Dropping an Undo Tablespace
Switching Undo Tablespaces
Viewing Information about Undo Tablespace

SQL Loader
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


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 07:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4