Name
DELETE
Synopsis
Oracle9i syntax:
DELETE [NOPROMPT] { [EXPIRED] { { BACKUP | COPY } [OFlistObjList
] [mntQualifer
[mntQualifer
]...] |recordSpec
[DEVICE TYPEdeviceSpecifier
[,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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.