Oracle in a Nutshell

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 
   [ OF listObjList ]
   [ 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.