#1
5th January 2016, 10:22 AM
| |||
| |||
Oracle DBA
Hello, I want to do the Oracle DBA course offered by the oracle and I want to know the details of the course.
|
#2
5th January 2016, 10:22 AM
| |||
| |||
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 |
|