5 Replies Latest reply on Feb 10, 2012 8:52 PM by Gary Graham-Oracle

    change default file locations

    Stuart Fleming
      On Windows XP I have all my scripts on my u: drive, sql developer opens files from the documents and settings directory.

      I want to change the default file location directory, but cannot find this setting in Preferences.

      Anyone have any idea on this?

        • 1. Re: change default file locations
          You choose the desired location on the first time, and the next time the SQL Developer will suggest the location that you chose earlier.
          • 2. Re: change default file locations
            From the help file

            To specify a nondefault SQLDEVELOPER_USER_DIR location, do either of the following:

            Set the SQLDEVELOPER_USER_DIR environment variable to specify another directory path.

            Edit the <sqldeveloper_install>\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file and substitute the desired directory path for SQLDEVELOPER_USER_DIR in the following line:
            SetUserHomeVariable SQLDEVELOPER_USER_DIR


            • 3. Re: change default file locations
              Stuart Fleming
              A bit Late, but thank you!
              • 4. Re: change default file locations
                Is there an equivalent option for SQL Developer 3.1? I would like to have both 3.1 and 3.0 installed on my machine, and run either. I share reports with others in the company, and those will need to stay at 3.0.

                I tried including the following in sqldeveloper.conf
                SetUserHomeVariable C:\Users\[myuserid]\AppData\Roaming\SQLDeveloper31
                This resulted in a warning:
                WARNING: Unknown directive: SetUserHomeVariable
                (Replacing back slashes with forward slashes made no difference)

                Windows 7
                SQL Developer 3.1 with bundled JDK.
                • 5. Re: change default file locations
                  Gary Graham-Oracle
                  Hi David,

                  According to documentation, the IDE_USER_DIR is picked up automatically if set, so there should be no need for an additional conf file set statement in any recent SQL Developer release. There is another way, however:

                  A similar case occurs when one wishes to run SQL Developer from a flash-drive and also keep user-related information on that drive, e.g.,

                  1. Unzip SQL Developer into E:\sqldeveloper
                  2. Add the following line to one of your conf files: ide\bin\jdk.conf, ide\bin\ide.conf, or sqldeveloper\bin\sqldeveloper.conf
                  AddVMOption -Dide.user.dir=../../.sqldeveloper
                  The path given is relative to a starting directory of E:\sqldeveloper\sqldeveloper\bin, 
                  so the directory containing user-related data will be E:\sqldeveloper\.sqldeveloper 
                  3. Note that the "include" sequence for these conf files is jdk.conf -> ide.conf -> sqldeveloper.conf

                  If you look in Help|About|Properties, you can scroll to find the ide.user.dir property and other related properties. The Help also documents which files or types of files will be stored there. See SQL Developer Concepts and Usages|SQL Developer Preferences, then Location of User-Related Information.

                  SQL Developer Team