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";