Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  PATHNAME path name
    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.
Close Help