A data dictionary path name can be:
o A full path name, such as CDD$TOP.MOLLY.SQL.PERSONNEL
o A relative path name
o A logical name for a full or relative path name
Unless you use the PATHNAME argument in the CREATE DATABASE
statement, SQL does not use the data dictionary to store data
definitions.
If you specify the PATHNAME argument when you first create a
database, SQL creates a path name that contains copies of data
definitions for the database.