Name
DELETE
Synopsis
Oracle9i syntax:
DELETE [NOPROMPT]
{ [EXPIRED]
{ { BACKUP | COPY }
[OF listObjList] [mntQualifer [mntQualifer]...]
| recordSpec
[DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
}
| OBSOLETE [obsoleteOpersList]
[DEVICE TYPE [deviceSpecifier [, deviceSpecifier]...]
};Oracle8i syntax:
DELETE EXPIRED BACKUP [ OFlistObjList] [deleteOptions[deleteOptions...]]; deleteOptions := { TAG [=] [']tag_name['] |completedTimeSpec}
For Oracle9i, deletes the physical files associated with backup sets and datafile copies, updates their status in the control file, and removes their information from the optional recovery catalog (if one is used).
In Oracle8i and Oracle9i, backups are flagged as EXPIRED if they cannot be found at their recorded location. Deletion of EXPIRED backups removes their information from the control file and from the optional recovery catalog (if one is used).
Keywords
- NOPROMPT
Deletes the specified files without confirmation.
- EXPIRED
Deletes files that have been marked as EXPIRED in the catalog.
- OBSOLETE
Deletes files that are no longer needed for recovery.
Common keywords and clauses: completedTimeSpec, listObjList, obsoleteOpersList, tag_name.