Applies to:
Oracle Discoverer - Version: 10.1.2.0.0 to 10.1.2.3Information in this document applies to any platform.
Goal
When exporting to various formats via Discoverer Plus 10g (10.1.2), the file is always sent to a location like "C:\Documents and Settings\
How can this default export location be changed?
Solution
The Sun java virtual machine plug-in used for Discoverer Plus is installed and is specific to each PC.
You can set some system-level properties per the Sun JVM "Deployment Configuration File and Properties Guide.
However, the guide does not specifically indicate you can set the user home at the system-level.
Setting the user home at the local PC level will allow changing the default export path for Sun JRE 1.4.
This option is only available for Sun JRE 1.4.
NOTE: For Sun JRE 1.5 and above, you can only specify a different location for all users (not for individual user), for more information please refer to Note 365245.1.
The user (or administrator) is required to make the following changes locally on every PC.
For Sun Java Plugin:
- Locate the file "C:\Documents and Settings\
\Application Data\Sun\Java\Deployment\deployment.properties",
and add the entry below :
user.home=
For example: If the new directory is: 'D:\DISCO_1012\TEMP', then the entry would look like this
(with double backslashes in lieu of a single backslash):
user.home=D:\\DISCO_1012\\TEMP
- Save the "deployment.properties" file once the entry is added.
- Close all browsers and relaunch Discoverer Plus in a new browser session.
- Run a workbook and perform export, which will attempt to export to the new directory.
For Oracle Jinitiator Plug-in:
1. Open Windows Control Panel, double click on "Jinitiator 1.3.1.xx" icon,
click on cache tab and note down the value set for Location under
"JAR cache Settings".
Suppose the value is set to "C:\WINNT\Profiles\jdoe\Oracle Jar Cache"
2. Click on Start >> Run
and type the command:
explorer %userprofile%\.jinit
This opens Windows Explorer with the current directory as %userprofile%\.jinit
3. Check if there is any file with name:
properties13xx (used by Jinitiator 1.3.1.xx)
4. If there is no such a file create a new file with name properties13xx
(for example properties1318, if using jinitiator 1.3.1.8) and add
the following entries:
jarcache.directory=
(make sure to put two backslashes in the place of single backslash)
user.home=
(make sure to put two backslashes in the place of single backslash)
For example:
user.home=D:\\TEMP
jarcache.directory=C:\\WINNT\\Profiles\\jdoe\\Oracle Jar Cache
(Note there are two '\' between directory name separators)
5. If there is already existing file properties13xx in the
%userprofile%\.jinit directory and jarcache.directory entry
exists in this file and it is pointing to a directory, then do not change it.
Only add the entry for user.home as shown in step 4 at the end of the file.
Before modifying properties13xx file, take a backup of those files.
6. Save the file.
7. Exit all the browser windows.
8. Invoke a new browser window to run Discoverer Plus.
Now export from Discoverer Plus should create files under the directory to
which user.home entry points to.
