Deletes the repository definitions. It does not delete the
    physical database files.

1  –  Environment

    You can use the DROP PATHNAME statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled

    o  As part of a procedure in an SQL module

    o  In dynamic SQL as a statement to be dynamically executed

2  –  Format

  (B)0DROP PATHNAME qqq> <path-name> qqq>                                             

3  –  Arguments

3.1  –  path-name

    Specifies the repository path name for the schema definitions.

    Specify either a full path name or a relative path name. If
    you use a relative path name, the current default repository
    directory must be defined to include all the path name segments
    that precede the relative path name.

4  –  Examples

    Example 1: Deleting a path name with the DROP PATHNAME statement

    The following example deletes CDD$TOP.SQL.DEPT3, a repository
    directory, and all its descendants. It does not delete the
    database system files or data that corresponds to that path name.

    SQL> DROP PATHNAME "CDD$TOP.SQL.DEPT3";