SQL Developer - (Installation|Configuration)

> Integrated development environment (ide) > Oracle Sql Developer

1 - About

(Installation|Configuration)

Advertising

3 - How to

3.1 - 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
sqldeveloper.exe

3.2 - TNS_ADMIN environment variable

3.3 - 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
Advertising

4 - Documentation / Reference