SQL Developer - (Installation|Configuration)

Sql Developer Encoding



How to

Metadata Backup

backup metadata such as connection, report, …

The best way is to search in the documentation of SQL Developer the section “Location of User-Related Information” in the concept chapter. This section gives you a detailed procedure on how to proceed in order to relocate the metadata directory of SQL Developer.

Example for the version 3, you have to set the environment variable IDE_USER_DIR. You can do it by creating a SQLDeveloper.bat file such as this one in the Sql Developer home directory

SET IDE_USER_DIR=C:\dropbox\Config\SqlDeveloper

TNS_ADMIN environment variable

Oracle Database - TNS_ADMIN environement variable

JDK Path

The conf file contains the Java Home option:

# SetJavaHome ../../jdk
SetJavaHome C:\Program Files\Java\jdk1.8.0_45\bin

The start configuration file of SQL Developer is :

  • Before 4.0: sqldeveloper_home\bin\sqldeveloper.conf
  • Since version 4:
    • For Windows: %APPDATA%\sqldeveloper\<version>\product.conf
    • For Linux: $HOME/./sqldeveloper/version/product.conf

Documentation / Reference

Discover More
Sql Developer Encoding
Oracle Sql Developer

Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You...
Timesten Component
Timesten - (SQL Developer|ODBC Client) Configuration

How to configure SQL Developer to connect to a Timesten Database. Download and install the last version of SQL Developer downloadSQL Developer To access a TimesTen database from SQL Developer,...

Share this page:
Follow us:
Task Runner