The repository path name for the repository directory where the
database definition is stored.
Specify one of the following:
o A full repository path name, such as CDD$TOP.SQL.DEPT3
o A relative repository path name, such as DEPT3
o A logical name that refers to a full or relative repository
path name
If you use a relative path name, CDD$DEFAULT must be defined
as all the path name segments preceding the relative path name.
For example, define CDD$DEFAULT as CDD$TOP.SQL, and then use the
relative path name DEPT3.
SQL> SHOW DICTIONARY
The current data dictionary is CDD$TOP.SQL
SQL> CREATE DATABASE ALIAS PERSONNEL PATHNAME DEPT3;
There is no default path name. If you do not specify a repository
path name for the database, SQL does not store database
definitions in the repository. Subsequent data definitions cannot
use the repository. However, Oracle Rdb recommends that you do
specify a repository path name when you create a database. For
more information, see the Oracle Rdb SQL Reference Manual.
If you use the PATHNAME argument and your system does not have
the repository, SQL ignores the argument.
When you use the PATHNAME argument, the repository associates
the path name with the file specification exactly as given in the
CREATE DATABASE statement. If that file specification is a file
name, not a logical name, you cannot alter or delete the database
by specifying the path name unless the database root file is in
the current, default working directory.