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.