ORACLE UTILITIES

1. Metadata API

1.1. Retrieve an object's metadata as XML

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

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

1.4. to use

1.4.1. DBMS_METADATA

2. SQL*Loader

2.1. loads data

2.1.1. from external files

2.1.1.1. into tables

3. External Tables

3.1. complement

3.1.1. SQL*Loader

4. DBNEWID Utility

4.1. change

4.1.1. DBID

4.1.2. DBNAME

5. Data Pump

5.1. Export

5.2. Import

5.2.1. can also be

5.2.1.1. network import

5.3. based on

5.3.1. Data Pump API

6. Data Pump API

6.1. DBMS_DATAPUMP

6.1.1. PL/SQL package

7. LogMiner

7.1. query

7.1.1. redo log files

7.2. Performance tuning and capacity planning through trend analysis

7.3. Performing post-auditing

8. DBVERIFY Utility

8.1. external command-line utility

8.2. perform

8.2.1. physical data structure integrity check

8.3. only for use

8.3.1. data files

8.4. not work

8.4.1. control files or redo log