Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 11g New Features (Part I)

Online Oracle Training

LESSON # 01:

You will learn:

How you can list all transactions from online redo log files and archived log files on the Oracle Enterprise Manager 11g. The tool rollbacks transactions using LogMinor to extract DML statements from the redo log files.

More ...


LESSON # 02:

You will learn:

The CONTINUE statement

How you can use the CONTINUE statement to go to the end of the loop and terminate the LOOP statement - examples

More ...


LESSON # 03:

You will learn:

How to create an Oracle database link (dblink) bi-directional. As you know, the Oracle database link is one way in direction. On this lesson, you will see steps to perform bi-directional link from one database to another.

More ...


LESSON # 04:

You will learn:

How to backup a database using the RMAN commands.

How to backup whole database

How to backup archivelog and control files

How to use the RMAN catalog

How to register and unregister a database to a catalog

How to remove objects from the flashback recovery area

How to recover a database or an object using flashback 

More ...


LESSON # 05:

You will learn:

About the Oracle Replay

Why we need the Oracle Replay

How to capture transactions

How to replay back transactions on another database

More ...


LESSON # 06:

You will learn:

About the Grid Control on the Oracle 11g

What the OMR (Oracle Management Repository) is

What the OMS (Oracle Management Service) is

What the OMA (Oracle Management Agent) is

How to access to the Grid Control console

More ...


LESSON # 07:

You will learn:

About the Oracle 11g Security

How to secure your database that only make connection with your application

How to create a trigger to prevent any accesses from other servers

More ...


LESSON # 08:

You will learn:

More about security and find a checklist recommendation to secure your databases

More ...


LESSON # 09:

You will learn:

About the SYSTEM Partitioning with an example

About the Interval Partitioning with an example

About the Reference Partitioning with an example

More ...


LESSON # 10:

You will learn:

About Partitioning on Virtual Columns with an example

More ...



. Part I          . Part II

Good Luck!!!!


Web web site