# Source: https://dbeaver.com/docs/dbeaver/Oracle/

Expand all

  * [ Getting started  ](..)

Getting started

    * [ First steps  ](../Getting-started/)
    * [ Installation  ](../Installation/)
    * [ Application window overview  ](../Application-Window-Overview/)
    * [ Basic operations  ](../Basic-operations/)
  * DBeaver configuration  DBeaver configuration 
    * [ User interface  ](../User-Interface-Themes/)
    * [ Interface language  ](../UI-Language/)
    * [ Accessibility  ](../Accessibility-Guide/)
    * [ Toolbar customization  ](../Toolbar-Customization/)
    * [ Database object editor  ](../Database-Object-Editor/)
    * [ Reset UI settings  ](../Reset-UI-settings/)
    * [ Shortcuts  ](../Shortcuts/)
  * Security  Security 
    * [ Security in DBeaver PRO  ](../Security-in-DBeaver-PRO/)
    * Password secure storage  Password secure storage 
      * [ Secure storage  ](../Security/)
      * [ Master password  ](../Managing-Master-Password/)
      * [ Automation (console) security  ](../Automation-Security/)
      * [ Integrated security  ](../Integrated-Security/)
    * [ Secret Management  ](../Secret-Providers/)
  * Configure connection  Configure connection 
    * Connection settings  Connection settings 
      * [ Create connection  ](../Create-Connection/)
      * [ Edit connection  ](../Edit-Connection/)
      * [ Invalidate and reconnect  ](../Invalidate-and-Reconnect-to-Database/)
      * [ Disconnect from database  ](../Disconnect-from-Database/)
      * [ Change current user password  ](../Change-current-user-password/)
      * [ Shell commands  ](../Working-with-Shell-Commands-in-DBeaver/)
      * [ Initialization settings  ](../Configure-Connection-Initialization-Settings/)
      * [ Security restrictions for database connection  ](../Managing-security-restrictions-for-database-connection/)
      * [ Connection types  ](../Connection-Types/)
      * [ Local client configuration  ](../Local-Client-Configuration/)
      * [ Multiple datasource connections  ](../Separate-Connections/)
    * Network configuration  Network configuration 
      * [ Network configuration  ](../Network-configuration/)
      * Connection network options  Connection network options 
        * [ SSH configuration  ](../SSH-Configuration/)
        * SSL  SSL 
          * [ SSL configuration  ](../SSL-Configuration/)
          * Truststore management  Truststore management 
            * [ Manage certificates  ](../Managing-Truststore-Settings/)
            * [ Import custom certificates  ](../Import-SSL-Certificates/)
          * [ Oracle SSL configuration  ](../SSL-Configuration-Oracle/)
        * Proxy  Proxy 
          * [ Proxy configuration  ](../Proxy-configuration/)
          * [ Proxy configuration with system files  ](../Proxy-configuration-with-system-files/)
        * [ Kubernetes configuration  ](../Kubernetes-configuration/)
        * [ AWS SSM configuration  ](../AWS-SSM-Configuration/)
      * [ Network profiles  ](../Network-profiles/)
    * Transaction mode  Transaction mode 
      * [ Transaction log  ](../Transaction-Log/)
      * [ Pending transactions  ](../Pending-Transactions/)
      * [ Auto and manual commit modes  ](../Auto-and-Manual-Commit-Modes/)
    * Database authentication models  Database authentication models 
      * [ Database native  ](../Authentication-Database-Native/)
      * [ DBeaver profile  ](../Authentication-DBeaver-profile/)
      * [ Microsoft Entra ID  ](../Authentication-Microsoft-Entra-ID/)
      * [ Kerberos  ](../Kerberos-Authentication/)
    * Driver settings  Driver settings 
      * [ Driver manager  ](../Driver-Manager/)
      * [ ODBC & JDBC driver  ](../ODBC-JDBC-Driver/)
      * [ File-based driver properties  ](../File-based-driver-properties/)
      * [ How to add additional artifacts to the driver  ](../How-to-add-additional-artifacts-to-the-driver/)
      * [ JDBC time zones  ](../JDBC-Time-Zones/)
      * [ JDBC tracing  ](../JDBC-Tracing/)
      * [ Deprecated legacy ODBC driver  ](../Deprecated-legacy-ODBC-driver/)
  * Databases support  Databases support 
    * [ Database drivers  ](../Database-drivers/)
    * Classic  Classic 
      * [ Apache Hive  ](../Apache-Hive/)
      * [ Cassandra  ](../Cassandra/)
      * [ ClickHouse  ](../Clickhouse/)
      * [ Couchbase  ](../Couchbase/)
      * [ IBM Db2  ](../Database-driver-IBM-Db2/)
      * [ Greenplum  ](../Database-driver-Greenplum/)
      * [ InfluxDB  ](../InfluxDB/)
      * [ Microsoft SQL Server  ](../Database-driver-Microsoft-SQL-Server/)
      * [ MariaDB  ](../Database-driver-MariaDB/)
      * MongoDB  MongoDB 
        * [ MongoDB  ](../MongoDB/)
        * [ MongoDB authentication  ](../Authentication-MongoDB/)
      * MySQL  MySQL 
        * [ MySQL  ](../Database-driver-MySQL/)
        * [ Two-factor authentication  ](../Authentication-MySQL-Two-factor/)
      * [ Netezza  ](../Database-driver-Netezza/)
      * Oracle  Oracle 
        * Oracle  [ Oracle  ](./) Table of contents 
          * Setting Up 
            * Oracle connection settings 
              * Connection details 
            * Oracle driver properties 
            * Secure Connection Configurations 
            * Secure Storage with Secret Providers 
          * Powering Oracle with DBeaver 
            * Oracle database objects 
            * Oracle features in DBeaver 
        * [ Oracle authentication  ](../Connecting-to-Oracle-databases/)
        * [ JDBC OCI driver  ](../Connecting-to-Oracle-Database-using-JDBC-OCI-driver/)
      * PostgreSQL  PostgreSQL 
        * [ PostgreSQL  ](../Database-driver-PostgreSQL/)
        * [ PgPass authentication  ](../Authentication-PostgreSQL-Pgpass/)
        * [ SSPI (Windows SSO)  ](../Authentication-PostgreSQL-SSPI/)
      * [ Redis  ](../Redis/)
      * Salesforce  Salesforce 
        * [ Salesforce  ](../Database-driver-Salesforce/)
        * [ Salesforce authentication  ](../Authentication-Salesforce/)
      * Teradata  Teradata 
        * [ Teradata  ](../Database-driver-Teradata/)
        * [ LDAP authentication in Teradata  ](../Authentication-LDAP-Mechanism/)
      * [ Trino  ](../Database-driver-Trino/)
      * [ Yellowbrick  ](../Database-driver-Yellowbrick/)
    * Cloud  Cloud 
      * AWS  AWS 
        * [ Athena  ](../Database-driver-Amazon-Athena/)
        * [ Aurora DSQL  ](../Database-driver-Aurora-DSQL/)
        * [ DocumentDB  ](../AWS-DocumentDB/)
        * [ DynamoDB  ](../AWS-DynamoDB/)
        * [ Keyspaces  ](../AWS-Keyspaces/)
        * [ Neptune  ](../Database-driver-Neptune/)
        * [ Redshift  ](../Database-driver-Amazon-Redshift/)
        * [ Timestream  ](../Database-driver-Amazon-Timestream/)
      * Azure  Azure 
        * [ Cosmos DB  ](../Database-driver-CosmosDB/)
        * [ Cosmos DB for NoSQL  ](../Database-driver-Azure-CosmosDB-for-NoSQL/)
      * Google  Google 
        * [ AlloyDB for PostgreSQL  ](../Database-driver-AlloyDB-for-PostgreSQL/)
        * [ BigQuery  ](../Database-driver-BigQuery/)
        * [ Bigtable  ](../Google-Bigtable/)
        * [ Cloud SQL for MySQL  ](../Database-driver-MySQL-on-Google-Cloud/)
        * [ Cloud SQL for PostgreSQL  ](../Database-driver-PostgreSQL-on-Google-Cloud/)
        * [ Cloud SQL for SQL Server  ](../Database-driver-Microsoft-SQL-Server-on-Google-Cloud/)
        * [ Firestore  ](../Database-driver-Firestore/)
        * [ Spanner  ](../Database-driver-Google-Cloud-Spanner/)
      * Databricks  Databricks 
        * [ Databricks  ](../Database-driver-Databricks/)
        * [ Databricks authentication  ](../Authentication-Databricks/)
      * Snowflake  Snowflake 
        * [ Snowflake  ](../Snowflake/)
        * [ Snowflake authentication  ](../Authentication-Snowflake/)
    * Embedded  Embedded 
      * [ SQLite  ](../Database-driver-SQLite/)
    * File drivers  File drivers 
      * [ Multi source  ](../Database-driver-Files-MultiSource/)
      * [ CSV  ](../Database-driver-CSV/)
      * [ JSON  ](../Database-driver-JSON/)
      * [ Parquet  ](../Database-driver-Parquet/)
      * [ XLSX  ](../Database-driver-XLSX/)
      * [ XML  ](../Database-driver-XML/)
    * Graph  Graph 
      * [ Neo4j  ](../Database-driver-Neo4j/)
  * Navigation  Navigation 
    * Database Navigator  Database Navigator 
      * [ Database Navigator  ](../Database-Navigator/)
      * [ Simple and advanced view  ](../Simple-and-Advanced-View/)
      * [ Configuring filters  ](../Configure-Filters/)
      * [ Filter database objects  ](../Filter-Database-Objects/)
      * [ Bookmarks  ](../Bookmarks/)
    * Projects  Projects 
      * [ Projects  ](../Projects/)
      * [ Projects view  ](../Projects-View/)
      * [ Project security  ](../Project-security/)
      * [ Project explorer  ](../Project-Explorer/)
    * Search  Search 
      * [ Search  ](../Search-Tool/)
      * [ Data search  ](../Data-Search/)
      * [ Full-text search database  ](../DB-Full-Text-Search/)
      * [ Metadata search  ](../DB-Metadata-Search/)
      * [ File search  ](../File-Search/)
  * [ Properties Editor  ](../Properties-Editor/)
  * Data Editor  Data Editor 
    * [ Data Editor  ](../Data-Editor/)
    * Viewing and editing data  Viewing and editing data 
      * [ Data view and format  ](../Data-View-and-Format/)
      * [ Data filters  ](../Data-Filters/)
      * [ Data viewing and editing  ](../Data-Viewing-and-Editing/)
      * [ Data refresh  ](../Data-Refresh/)
      * [ Result set navigation  ](../Navigation/)
      * Panels  Panels 
        * [ Panels  ](../Panels/)
        * [ Value Panel  ](../Value-Panel/)
        * [ References Panel  ](../References-Panel/)
        * [ Metadata Panel  ](../Metadata-Panel/)
        * [ Grouping Panel  ](../Grouping-Panel/)
        * [ Calc Panel  ](../Calc-Panel/)
        * [ Result details Panel  ](../Result-Details-Panel/)
        * [ Query trace Panel  ](../Query-Trace-Panel/)
      * [ Managing charts  ](../Managing-Charts/)
      * [ Mock data generation  ](../Mock-Data-Generation-in-DBeaver/)
      * [ Dashboards  ](../Dashboards/)
    * [ XML and JSON data  ](../Working-with-XML-and-JSON/)
    * [ Dictionary data  ](../Working-with-Dictionary-Data/)
    * [ Spatial GIS data  ](../Working-with-Spatial-GIS-data/)
    * Virtual entities  Virtual entities 
      * [ Virtual columns  ](../Virtual-column-expressions/)
      * [ Virtual keys  ](../Virtual-Keys/)
    * [ Data Editor preferences  ](../Data-Editor-preferences/)
    * [ Data format preferences  ](../Managing-Data-Formats/)
  * SQL Editor  SQL Editor 
    * [ SQL Editor  ](../SQL-Editor/)
    * [ Visual query builder  ](../Visual-Query-Builder/)
    * Query execution  Query execution 
      * [ SQL execution  ](../SQL-Execution/)
      * [ Query execution plan  ](../Query-Execution-Plan/)
      * [ Script management  ](../Script-Management/)
    * Query development and assistance  Query development and assistance 
      * [ SQL Assist and Auto Complete  ](../SQL-Assist-and-Auto-Complete/)
      * [ SQL templates  ](../SQL-Templates/)
      * [ SQL query formatter  ](../SQL-Formatting/)
      * [ Variables panel  ](../Variables-panel/)
      * [ Spelling  ](../Spelling/)
    * [ SQL generation  ](../SQL-Generation/)
    * [ SQL terminal  ](../SQL-Terminal/)
    * Client side commands  Client side commands 
      * [ Client side scripting  ](../Client-Side-Scripting/)
      * [ Export command  ](../Export-Command/)
    * [ Query manager  ](../Query-Manager/)
    * [ SQL code Editor  ](../SQL-Code-Editor/)
    * [ SQL Plus script execution  ](../SQL-Plus-Script-Execution/)
    * [ PostgreSQL Arrays  ](../PostgreSQL-Arrays/)
    * [ PostgreSQL Extensions  ](../PostgreSQL-Extensions/)
  * Entity relation diagrams  Entity relation diagrams 
    * [ ER Diagrams  ](../ER-Diagrams/)
    * [ Database structure diagrams  ](../Database-Structure-Diagrams/)
    * [ Custom diagrams  ](../Custom-Diagrams/)
    * [ Edit mode for diagrams  ](../Edit-mode/)
  * Cloud services  Cloud services 
    * Cloud explorer  Cloud explorer 
      * [ Cloud explorer  ](../Cloud-Explorer/)
      * [ AWS cloud explorer  ](../AWS-Cloud-Explorer/)
      * [ Azure cloud explorer  ](../Azure-Cloud-Explorer/)
      * [ Google cloud explorer  ](../Google-Cloud-Explorer/)
    * [ Cloud storage  ](../Cloud-Storage/)
    * Cloud connection settings  Cloud connection settings 
      * AWS  AWS 
        * [ AWS permissions  ](../AWS-Permissions/)
        * [ AWS SSO  ](../AWS-SSO/)
        * [ AWS credentials  ](../AWS-Credentials/)
      * Azure  Azure 
        * [ Azure permissions  ](../Azure-Permissions/)
      * Google Cloud  Google Cloud 
        * [ Google Cloud SSO  ](../GCP-SSO/)
        * [ Google Cloud credentials  ](../GCP-Credentials/)
  * AI  AI 
    * [ AI Assistant  ](../AI-Smart-Assistance/)
    * [ Data privacy  ](../AI-Assistance-and-Data-Privacy/)
    * Features  Features 
      * AI chat  AI chat 
        * [ AI chat  ](../AI-chat/)
        * [ Speech recognition  ](../AI-speech-recognition/)
      * AI functions  AI functions 
        * [ AI functions  ](../AI-Functions/)
        * [ Data transfer actions  ](../Data-Transfer-Actions/)
        * [ Advanced metadata actions  ](../Advanced-Metadata-Read-Actions/)
        * [ View and editor actions  ](../View-and-Editor-Actions/)
      * Work with SQL  Work with SQL 
        * [ Query suggestion  ](../AI-query-suggestion/)
        * [ Explain query  ](../AI-query-explanation/)
        * [ Fix SQL errors  ](../AI-error-explanation/)
        * [ AI command  ](../AI-command/)
      * Work with objects  Work with objects 
        * [ Describe object with AI  ](../AI-smart-metadata-description/)
    * Tutorials  Tutorials 
      * [ Quick start with AI  ](../Quick-start-with-AI-Assistance/)
    * Settings  Settings 
      * [ AI Assistant settings  ](../AI-Assistance-settings/)
      * Providers  Providers 
        * [ OpenAI  ](../AI-integration-with-OpenAI/)
        * [ GitHub Copilot  ](../AI-integration-with-GitHub-Copilot/)
        * [ Azure OpenAI  ](../AI-integration-with-Azure-OpenAI/)
        * [ Google Gemini  ](../AI-integration-with-Google-Gemini/)
        * [ Ollama  ](../AI-integration-with-Ollama/)
        * [ Anthropic Claude  ](../AI-integration-with-Anthropic-Claude/)
        * [ Amazon Bedrock  ](../AI-integration-with-Amazon-Bedrock/)
      * [ Disable AI Assistant  ](../Disable-AI-assistance/)
  * Data transfer and schema compare  Data transfer and schema compare 
    * Data transfer  Data transfer 
      * [ Data transfer  ](../Data-transfer/)
      * [ Data import  ](../Data-import/)
      * [ Data import and replace  ](../Data-Import-and-Replace/)
      * [ Data export  ](../Data-export/)
      * [ Data transfer external storage  ](../Data-transfer-external-storage/)
      * [ Data migration  ](../Data-migration/)
      * [ Data transfer via email  ](../Data-transfer-email/)
    * [ Data compare  ](../Data-compare/)
    * [ Backup and restore  ](../Backup-Restore/)
    * Schema compare  Schema compare 
      * [ Schema compare  ](../Schema-compare/)
      * [ Liquibase support  ](../Using-Liquibase-in-DBeaver/)
  * Tasks  Tasks 
    * [ Task management  ](../Task-Management/)
    * [ Task scheduler  ](../Task-Scheduler/)
    * [ Composite tasks  ](../Composite-Tasks/)
  * Integrated tools  Integrated tools 
    * [ GIT integration  ](../Project-team-work/)
    * [ Tableau integration  ](../Tableau-integration-in-DBeaver/)
    * [ Database debugger (PostgreSQL)  ](../PGDebugger/)
    * [ Session Manager  ](../Session-Manager-Guide/)
    * [ Lock Manager  ](../Lock-Manager/)
    * [ Eclipse extensions  ](../Eclipse-extensions/)
  * Tutorials  Tutorials 
    * Table Creation  Table Creation 
      * [ New table creation  ](../New-Table-Creation/)
      * [ Incorporating triggers  ](../Incorporating-Triggers/)
      * [ Creating columns  ](../Creating-columns/)
      * [ Creating indexes  ](../Creating-Indexes/)
      * [ Implementing constraints  ](../Implementing-Constraints/)
      * [ Utilizing foreign keys  ](../Utilizing-Foreign-Keys/)
    * [ Sample database  ](../Sample-Database/)
    * [ Database partitions  ](../How-to-work-with-database-Partitions/)
    * [ Import connections from external tools  ](../How-to-import-Connections-from-External-Tools/)
  * Administration  Administration 
    * Admin preferences  Admin preferences 
      * [ Admin manage preferences  ](../Admin-Manage-Preferences/)
      * [ Admin manage drivers  ](../Admin-Manage-Drivers/)
      * [ Admin preference restrictions  ](../Admin-Preference-Restrictions/)
      * [ Admin variables  ](../Admin-Variables/)
    * General configuration  General configuration 
      * [ Configuration files  ](../Configuration-files-in-DBeaver/)
      * [ Pre-configured database connections  ](../Admin-Manage-Connections/)
      * [ Pre-configured variables  ](../Pre-configured-Variables/)
      * [ How to set a variable if dbeaver.ini is read only  ](../How-to-set-a-variable-if-dbeaver-ini-is-read-only/)
      * [ Command line  ](../Command-Line/)
      * [ Error log  ](../Log-files/)
      * [ Background tasks  ](../Background-Tasks/)
      * [ Workspace location  ](../Workspace-Location/)
      * [ Resetting your workspace  ](../Reset-workspace/)
      * [ Importing CA certificates from your local Java into DBeaver  ](../Importing-CA-certificates-from-your-local-Java-into-DBeaver/)
    * Troubleshooting  Troubleshooting 
      * [ Troubleshooting system issues  ](../Troubleshooting-system-issues/)
      * [ Troubleshooting task scheduler issues  ](../Troubleshooting-task-scheduler-issues/)
      * [ Making a thread dump  ](../Making-a-thread-dump/)
      * [ Posting issues  ](../Posting-issues/)
    * [ Windows silent install  ](../Windows-Silent-Install/)
    * [ Snap installation  ](../Snap-installation/)
  * Licenses  Licenses 
    * [ Import license  ](../How-to-Import-License/)
    * [ Update license  ](../How-to-Update-License/)
    * [ Reassign license  ](../How-to-Reassign-License/)
    * [ License administration  ](../License-Administration/)
    * License types  License types 
      * [ License types  ](../Differences-between-license-types/)
      * [ Early Access Program (EAP) license  ](../Early-Access-Program-license/)
  * About DBeaver  About DBeaver 
    * Editions  Editions 
      * [ Enterprise edition  ](../Enterprise-Edition/)
      * [ Lite edition  ](../Lite-Edition/)
      * [ Ultimate edition  ](../Ultimate-Edition/)
    * [ Release cycles  ](../DBeaver-release-cycles/)
    * [ Statistics collection  ](../Statistics-Collection/)
    * [ Customer technical support  ](../Customer-technical-support-information/)
  * [ FAQ  ](../FAQ/)

Table of contents

  * Setting Up 
    * Oracle connection settings 
      * Connection details 
    * Oracle driver properties 
    * Secure Connection Configurations 
    * Secure Storage with Secret Providers 
  * Powering Oracle with DBeaver 
    * Oracle database objects 
    * Oracle features in DBeaver 

  1. [DBeaver](/docs/dbeaver)
  2. [Databases support](/docs/dbeaver/Database-drivers)
  3. [Classic](/docs/dbeaver/Apache-Hive)
  4. Oracle

# Oracle

This guide provides instructions for setting up and using Oracle with DBeaver.

Before you start, you must create a connection in DBeaver and select Oracle.
If you haven't done this, please refer to our [Database Connection](../Create-
Connection/) article.

DBeaver interacts with the Oracle server using a specific driver. It supports
all versions of Oracle, but the correct driver must be selected: use 'Oracle
(Legacy)' for versions `8.x`, `9.x`, `10.x` and 'Oracle' for version `11` and
later. It also supports Oracle cloud database extensions such as Oracle Cloud
JSON and Oracle NetSuite, both of which can be connected through [Cloud
Explorer](../Cloud-Explorer/).

![](../images/database/oracle/oracle-driver.png)

## Setting Up¶

This section provides an overview of DBeaver's settings for establishing a
direct connection and the configuration of secure connections using SSH,
proxies, and the driver setup for Oracle.

### Oracle connection settings¶

In this subsection, we'll outline the settings for establishing a direct
connection to a Oracle database using DBeaver. Correctly configuring your
connection ensures seamless interaction between DBeaver and your Oracle
database.

  1. The **Main** tab of the connection settings requires you to fill in specific fields to establish the initial connection.

![](../images/database/oracle/oracle-connection-main.png)

Field | Description  
---|---  
**Host** | If you're connecting via host, enter the host address of your Oracle database here.  
**Database** | Enter the name of the Oracle database you want to connect to.  
**Port** | Enter the port number for your Oracle database. The default Oracle port is `1521`.  
**Connection identifiers** | Choose whether you want to connect using a `Service name` or a `SID` identifier.  
**Authentication** | Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles:  
  
\- [Oracle Database Native](../Authentication-Database-Native/)  
\- [OS Authentication](../Connecting-to-Oracle-databases/#os-authentication)
![](../images/commercial.png)  
\- [DBeaver Profile Authentication](../Authentication-DBeaver-profile/)
![](../images/commercial.png)  
\- [Oracle Kerberos Authentication](../Kerberos-Authentication/)
![](../images/commercial.png)  
\- [Oracle Wallet](../Connecting-to-Oracle-databases/#oracle-wallet-
connection) ![](../images/commercial.png)  
  
You can also read about [security in DBeaver PRO](../Security-in-DBeaver-
PRO/).  
**Role** | Choose whether you want to connect using a `Normal`, `SYSDABA` or a `SYSOPER` role. For more details, you can refer to the official [Administering User Accounts and Security](https://docs.oracle.com/cd/E11882_01/server.112/e10897/users_secure.htm#ADMQS007) article.  
**Connection Details** | Provide additional connection details if necessary.  
**Driver Name** | This field will be auto-filled based on your selected driver type.  
**Driver Settings** | If there are any specific driver settings, configure them here.  
  2. The **Oracle Properties** page of the connection settings offers additional options that allow you to customize your further connection to the Oracle database.

![](../images/database/oracle/oracle-properties-page.png)

Field | Description  
---|---  
**Language** | Specify the Session Language.  
**Territory** | Specify the Session Territory.  
**NLS Date Format** | Specify NLS (National Language Support) Date Format. The default value of the `NLS_DATE_FORMAT` parameter is determined by the `TERRITORY` parameter.  
**NLS Timestamp Format** | Specify NLS Timestamp format. The default value of the `NLS_TIMESTAMP_FORMAT` parameter is determined by the `TERRITORY` parameter.  
**Length semantics** | specify the length semantics for `VARCHAR2` and `CHAR` table columns, user-defined object attributes, and PL/SQL variables in database objects created in the session. The length semantics can be specified as either `BYTE` or `CHAR`.  
**Currency symbol** | Specify the Currency symbol.You can find out which currency symbol your current session uses by querying the `V$NLS_PARAMETERS` view.  
**Show only connected user schema** | Show only a scheme of a connected user in the [Database Navigator](../Database-Navigator/).  
**Hide empty schemas** | Check existence of objects within schema and do not show empty schemas in tree. Enabled by default but it may cause performance problems on databases with very big number of objects.  
**Always show`DBA` objects** | Always shows DBA-related metadata objects in tree even if user do not has `DBA` role.  
**Always use`DBA_*` views** | Use `DBA_*` views instead of `ALL_*` views wherever it is possible  
**Use SYS schema prefix** | Use SYS schema prefix in all metadata queries. Otherwise use view names without explicit schema.  
**Simple constraint reading query** | Use simple metadata queries. May work slower but it is more stable for all Oracle versions.  
**Use UNION for table metadata reading** | Use legacy table metadata query. With `UNION` instead `JOIN`. It helps in some cases speed up reading of table data.  
**Search metadata in synonyms** | Search for metadata in synonyms so theyâre available in [autocomplete](../SQL-Assist-and-Auto-Complete/), semantic validation, and [Outline](../SQL-Editor/#outline). May significantly slow down metadata search and autocompletion.  
**Search metadata in sequences** | Search for metadata in sequences so theyâre available in [autocomplete](../SQL-Assist-and-Auto-Complete/), semantic validation, and [Outline](../SQL-Editor/#outline). May significantly slow down metadata search and autocompletion.  
**Use RULE hint for system catalog queries** | Adds `RULE` hint for some system catalog queries (like columns and constraints reading).It significantly increases performance on some Oracle databases (and decreases on others).  
**Show DATE values specifically as DATE** | Show `DATE` data type values specifically as `DATE`, not as a `TIMESTAMP`.This setting will not work with disabled date/time formatting.  
**Use metadata queries optimizer** | Use metadata queries optimizer. May significantly improve metadata reading performance on some systems.  

#### Connection details¶

The **Connection Details** section in DBeaver allows to customize your
experience while working with Oracle database. This includes options for
adjusting the **Navigator View** , setting up **Security** measures, applying
**Filters** , configuring **Connection Initialization** settings, and setting
up **Shell Commands**. Each of these settings can significantly impact your
database operations and workflow. For detailed guides on these settings,
please refer to the following articles:

  * [Connection Details Configuration](../Create-Connection/#connection-details)
  * [Database Navigator](../Database-Navigator/)
  * [Security Settings Guide](../Managing-security-restrictions-for-database-connection/)
  * [Filters Settings Guide](../Configure-Filters/)
  * [Connection Initialization Settings Guide](../Configure-Connection-Initialization-Settings/)
  * [Shell Commands Guide](../Working-with-Shell-Commands-in-DBeaver/)

### Oracle driver properties¶

The settings for Oracle **Driver properties** enable you to adjust the
performance of the Oracle driver. These adjustments can influence the
efficiency, compatibility, and features of your Oracle database.

For a complete walkthrough on setting up Oracle JDBC driver properties, you
can refer to the official [Oracle JDBC
documentation](https://docs.oracle.com/en/database/oracle/oracle-
database/21/jajdb/oracle/jdbc/OracleConnection.html). These guide detail each
driver's properties and how they can be used to optimize Oracle database
connections.

You can customize the Oracle driver in DBeaver via the **Edit Driver** page,
accessible by clicking on the **Driver Settings** button on the first page of
the driver settings. This page offers a range of settings that can influence
your Oracle database connections. For a comprehensive guide on these settings,
please refer to our [Driver manager](../Driver-Manager/) article.

### Secure Connection Configurations¶

DBeaver supports secure connections to your Oracle database. Guidance on
configuring such connections, specifically **SSH** , **Proxy** ,
**Kubernetes** , **AWS SSM** and **SSL** connections, can be found in various
referenced articles. For a comprehensive understanding, please refer to these
articles:

  * [**SSH Configuration**](../SSH-Configuration/)

  * [**Proxy Configuration**](../Proxy-configuration/)

  * [**SSL Configuration**](../SSL-Configuration/)

  * [**Kubernetes Configuration**](../Kubernetes-configuration/) ![](../images/commercial.png)

  * [**AWS SSM**](../AWS-SSM-Configuration/) ![](../images/commercial.png)

### Secure Storage with Secret Providers¶

DBeaver supports various cloud-based secret providers to retrieve database
credentials. For detailed setup instructions, see [Secret
Providers](../Secret-Providers/).

## Powering Oracle with DBeaver¶

DBeaver provides a host of features designed for Oracle databases. This
includes the ability to view and manage databases, along with numerous unique
capabilities aimed at optimizing database operations.

### Oracle database objects¶

DBeaver lets you view and manipulate a wide range of Oracle database objects.
DBeaver has extensive support for various Oracle metadata types, allowing you
to interact with a wide variety of database objects, such as:

  * Schemas
    * Tables
      * Columns
      * Constraints
      * Foreign Keys
      * References
      * Triggers
      * Indexes
      * Partitions
      * Dependencies
    * Views
    * Materialized Views
    * Indexes
    * Sequences
    * Queues
    * Types
    * Packages
    * Procedures
    * Functions
    * Synonyms
    * Schema Triggers
    * Table Triggers
    * Database Links
    * Java
    * Jobs
    * Scheduler
      * Jobs
      * Programs
    * Recycle bin
  * Global metadata
    * Types
    * Public Synonyms
    * Public Database Links
    * User Recycle bin
  * Storage
    * Tablespaces
      * Files
      * Objects
  * Security
    * Users
    * Roles
    * Profiles
  * Administer
    * Session Manager
    * Locks Manager

### Oracle features in DBeaver¶

DBeaver isn't limited to typical SQL tasks. It also includes numerous unique
features specifically for Oracle. Beyond regular SQL operations, DBeaver
provides a range of Oracle-specific capabilities, such as:

Category | Feature  
---|---  
Data Types | Oracle Nested Tables  
PL/SQL Support | PL/SQL Procedures  
| PL/SQL Functions  
Security | Oracle Permissions  
| Oracle Profiles  
| Oracle Roles  
| Changing Password ![](../images/commercial.png)  
User Management | Create/Clone Users ![](../images/commercial.png)  
Data Organization | [Oracle Partitions](../How-to-work-with-database-Partitions/#creating-partitions-in-oracle)  
Database Management | Oracle Dependencies  
Performance Tuning | Oracle Performance Reports  
| Oracle Execution Plans  
Script execution | [Execute scripts and commands with **SQL Plus** syntax](../SQL-Plus-Script-Execution/)  
  
Additional features compatible with Oracle, but not exclusive to it:

Category | Feature  
---|---  
Data Transfer | [Data Import](../Data-import/)  
| [Data Export](../Data-export/)  
Session Management | [Session Manager](../Session-Manager-Guide/)  
Backup and Restore | [How to Backup/Restore data](../Backup-Restore/)  
Schema Management | [Schema Compare ](../Schema-compare/)  
Data Visualization | [GIS Guide](../Working-with-Spatial-GIS-data/)  
| [ERD Guide](../ER-Diagrams/)  
  
Back to top