Describes packages and tools to query and validate data with Autonomous Transaction Processing.
External data is not managed by the database; however, you can use
DBMS_CLOUD procedures to query
your external data. Although queries on external data will not be as fast as queries on
database tables, you can use this approach to quickly start running queries on your
external source files and external data. Depending on the type of external table, you
can validate external data using the
DBMS_CLOUD validation procedures. The data validation
procedures let you validate the source files for an external table so that you can
identify problems and either correct the data in the external table or exclude invalid
data before you use the data.
Note:If you are not using
ADMINuser, ensure the user has the necessary privileges for the operations the user needs to perform. See Manage User Privileges with Autonomous Transaction Processing for more information.