Oracle

Choose Oracle under Engine, or paste:

oracle://user:password@localhost:1521/FREEPDB1

The path is the service name. The default port is 1521. You can also paste a JDBC URL such as jdbc:oracle:thin:@//localhost:1521/FREEPDB1.

Schemas

Each Oracle user is a schema. Tamery opens your own schema and lists the other schemas you can see. Oracle's built-in accounts, such as SYS and XDB, stay hidden.

New schema creates a locked user that owns the new objects, then its first table. That needs a DBA account, or these privileges: CREATE USER, CREATE ANY TABLE, CREATE ANY INDEX, CREATE ANY SEQUENCE, SELECT ANY SEQUENCE, and SELECT ANY TABLE. Tamery checks them before it creates anything.

Names

A name you type for a new table, view, column, schema, index, constraint, function, or trigger is stored in upper case, the way Oracle stores a name written without quotes. So orders becomes ORDERS, and your SQL can refer to it without quotes. Existing objects keep their names until you rename them.

Encryption

Add ssl=true to connect over TCPS, Oracle's TLS listener (often port 2484):

oracle://user:[email protected]:2484/ORCLPDB1?ssl=true

Without it, Tamery connects over plain TCP.

Transactions and schema changes

Each statement in a Query tab commits when it runs. Oracle commits schema changes immediately, so a failed change can leave earlier ones applied.

End a PL/SQL block, function, procedure, or trigger with a line holding only / when more statements follow it.

Limits

• SSH tunnels are not available for Oracle connections.
• Wallets and tnsnames.ora aliases are not supported. Use the host, port, and service name.

Local Oracle in Docker

docker run -d -p 1521:1521 -e ORACLE_PASSWORD=password gvenzl/oracle-free

Connect as system to the FREEPDB1 service. On desktop, Tamery lists the running container under detected databases.