Data_DUMP_DIR is created by default during DBCA installation of the DB..not sure, how can delete it thru SQL statements..