Remote Roots

Some database data is not stored in the database file itself, but as separate files in remote root directories.

Remote root directories do not have to be on the same drive, or even the same machine, as the database.

Editing of remote root locations is restricted to database owners when user permissions are enabled and the Protect Global Settings options is on.

Setting remote root locations

Note:

• When working with a standalone database, the remote root directory is set to be below the database by default. Data files are stored in a sub-directory of the directory containing the standalone database file.
• When working with a SQL Server or Oracle database, the location of all remote roots must be set before the database can be used.

To set remote root locations:

1. Select the Database management | Set remote roots option from the File menu. This displays the Set Remote Roots dialog.
2. Set locations for each remote root by typing the pathname of the directory, or browse for a directory using the button.

Files will be stored in a sub-directory of the specified Remote Root. The sub-directory name is the Unique Database Identifier for the database.

For information about the files stored in the remote root directories, see File Locations.