ORACLE UTILITIES

Data Pump

Export

Import

can also be, network import

based on

Data Pump API

DBMS_DATAPUMP

PL/SQL package

Metadata API

Retrieve an object's metadata as XML

Transform the XML in a variety of ways, including transforming it into SQL DDL

Submit the XML to re-create the object extracted by the retrieval

to use

DBMS_METADATA

SQL*Loader

loads data

from external files, into tables

External Tables

complement

SQL*Loader

LogMiner

query

redo log files

Performance tuning and capacity planning through trend analysis

You can determine which tables get the most updates and inserts. That information provides a historical perspective on disk access statistics, which can be used for tuning purposes.

Performing post-auditing

The redo log files contain all the information necessary to track any DML and DDL statements run on the database, the order in which they were run, and who executed them

DBVERIFY Utility

external command-line utility

perform

physical data structure integrity check

only for use

data files

not work

control files or redo log

DBNEWID Utility

change

DBID

DBNAME