SQL Developer - (Installation|Configuration)



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

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

Powered by ComboStrap