Learn how to store some on-premise database data that is not stored in the database file itself, 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.
Remote root directories are set by the Administrator . Editing of remote root locations is restricted to database owners when user permissions are enabled and the Protect Global Settings option is on.
Note: Everyone working with a particular on-premise database should use the same remote root directories.
Remote root locations are set by the Administrator:
- When working with the supplied 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 database file.
- When working with a SQL Server database, the location of all remote roots must be set before the database can be used.
- When working with an Oracle database, the location of all remote roots must be set before the database can be used.
To set remote root locations
- Choose File
Database settings Set remote roots. This displays the Set Remote Roots dialog.
- Set locations for each remote root by typing the pathname of the directory, or browse for a directory by 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 on-premise database.