Some on-premise database data is not stored in the database file itself, but as separate files in remote root folders.
Remote root folders do not have to be on the same drive, or even the same machine, as the on-premise database.
Editing of remote root locations is restricted to database owners when user permissions are enabled and the Protect Global Settings options is on.
Note: Everyone working with a particular
on-premise database should use the same remote root folders.
Setting remote root locations
Note:
- When working with a standalone database, the remote root folder is set to be below the database by default. Data files are stored in a sub-folder of the folder 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
- Select the Database management
Set remote roots option from the File menu. This displays the Set Remote Roots dialog.
- Set locations for each remote root by typing the pathname of the folder, or browse for a folder using the
button.
Files will be stored in a sub-folder of the specified Remote Root. The sub-folder name is the Unique Database Identifier for the on-premise database.
For information about the files stored in the remote root folder, see File Locations.