DBA Utilities

This course describes how to use Oracle Database utilities for data transfer, data maintenance, and database administration. You will learn how to archive data, back up an Oracle database, or move data between Oracle databases using the Export and Import utilities, load data into Oracle tables from operating system files using SQL*Loader, or from external sources using the external tables feature, perform a physical data structure integrity check on an offline database, using the DBVERIFY utility, maintain the internal database identifier (DBID) and the database name (DBNAME) for an operational database, using the DBNEWID utility, extract and manipulate complete representations of the metadata for database objects, using the Metadata API, query and analyze redo log files (through a SQL interface), using the LogMiner utility, use the Automatic Diagnostic Repository Command Interpreter (ADRCI) utility to manage Oracle Database diagnostic data and use Oracle Enterprise Manager Control to manage and monitor databases.

The Completion Level of Your Training.

0.00%

Start Here

About Author

How To get The Most Out Of This Course

What You Will Learn

SQL*Plus

Overview Of Features

Demo

SQL*Loader

Overview Of Features

Demo

Oracle Data Pump

Overview Of Features

Demo

External Tables

Overview Of Features

Demo

ADRCI

Overview Of Features

Demo

DBNEWID Utility

Overview Of Features

Demo

Oracle Enterprise Manager Cloud Control

Overview Of Features

Demo

Recovery Manager

Overview Of Features

Demo

DGMGRL

Overview Of Features

Demo

ASMCMD

Overview Of Features

Demo

DBCA

Overview Of Features

Demo

DBUA

Overview Of Features

Demo

SRVCTL

Overview Of Features

Demo

EMCTL

Overview Of Features

Demo

LSNRCTL

Overview Of Features

Demo

Database Views

New Lesson

Database Scripts

New Lesson

SQL Developer