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.