Part IV Other Utilities
Other Oracle data management utilities include the ADR Command Interpreter,
DBVERIFY
, Oracle LogMiner, the DBMS_METADATA
API,
and the legacy data movement utilities.
- Cloud Premigration Advisor Tool
To evaluate the compatibility of the source database before you migrate to an Oracle Cloud database, use the Cloud Premigration Advisor Tool (CPAT). - ADRCI: ADR Command Interpreter
The Automatic Diagnostic Repository Command Interpreter (ADRCI) utility is a command-line tool that you use to manage Oracle Database diagnostic data. - DBVERIFY: Offline Database Verification Utility
DBVERIFY is an external command-line utility that performs a physical data structure integrity check. - DBNEWID Utility
DBNEWID
is a database utility that can change the internal database identifier (DBID
) and the database name (DBNAME
) for an operational database. - Using LogMiner to Analyze Redo Log Files
LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. - Using the Metadata APIs
TheDBMS_METADATA
APIs enable you to check and update object metadata. - Original Import
The original Import utility (imp
) imports dump files that were created using the original Export utility (exp
).