ORACLE UTILITIES

Get Started. It's Free
or sign up with your email address
ORACLE UTILITIES by Mind Map: 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