Oracle

Connect Oracle Database with the Oracle database type. Amazon RDS for Oracle connects the same way.

Connect a database

Add the database as in Connect a database, with these values:

FieldValue
Database typeOracle
Port1521, Oracle's listener default.
Database nameThe service name, for example ORCLPDB1, or FREEPDB1 on Oracle Database Free. To connect by SID instead, prefix it with a colon, as in :ORCL.

For the credential, create a read-only user. To keep QueryDesk's queries off your primary, connect a read replica.

Tables

The schema sync reads the tables that the default credential's user owns. A read-only user owns none, so with it as the default credential the table list is empty, and queries name each table with its owner, as in SELECT * FROM app.orders.

AI read-only

With Read only set, an AI query's statements share one read-only transaction that is always rolled back, and Oracle refuses DML from a function called in a query. The parser also refuses utl_http and the other network packages, and httpuritype, which fetch a URL. See AI governance.

Was this page helpful?