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). - DBMS_CLOUD Family of Packages
To use theDBMS_CLOUD
and other packages in theDBMS_CLOUD
family of packages, you must complete certain tasks. - Oracle SQL Access to Kafka
Starting with Oracle Database 23ai, you can use Oracle SQL APIs to query Kafka topics dynamically using Oracle SQL. - 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
).