name ... → The names of one or more objects, separated by spaces or commas. DELETE removes the definitions of … names and the AW argument in the same DELETE command. When you do not use a qualified object name or … OLAP does not warn you when you delete an object that has the same name as an existing object in … another attached workspace.
Examples → 'SYSDATE-31'; DELETE NOPROMPT EXPIRED BACKUPSET OF TABLESPACE users DEVICE TYPE sbt COMPLETED BEFORE … archived redo logs that are no longer needed: DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS … copies (including archived redo logs) that have already been backed up at least twice to tape: DELETE … NOPROMPT BACKUP BACKED
Restrictions and Usage Notes → The target instance must be started. The DELETE command can delete usable backups and copies from … prior incarnations. A maintenance channel is not required when DELETE is used with a file that is … automatic maintenance channel. If you use DELETE on files that are not disk-only, and if you have … have only a
Restrictions on the DML_table_expression Clause → subquery of the DML_table_expression_clause. You cannot delete from a view except through INSTEAD OF … DELETE statement will fail unless the SKIP_UNUSABLE_INDEXES initialization parameter has been set to … true. See Also: ALTER SESSION w here_clause Use the where_clause to delete only rows that satisfy … subquery. You can delete
DELETE → Purpose Use the DELETE statement to remove rows from: An unpartitioned or partitioned table The … materialized view. Additional Topics Prerequisites Syntax Semantics Examples Prerequisites For you to delete … rows from a table, the table must be in your own schema or you must have the DELETE object privilege … on the table. For
DELETE → Syntax delete::= Text description of delete maintSpec::= Text description of maintSpec
DELETE → The DELETE command d eletes one or more objects from a workspace. The deletion becomes permanent … when you execute the UPDATE and COMMIT commands. Syntax DELETE name... [AW workspace ] Arguments
Purpose → To delete physical backups and copies as well as do the following: Update their repository records … catalog (if you use a catalog) When running RMAN interactively, DELETE displays a list of the files and … example, you back up a log to disk and then use an operating system utility to delete the file. If you do … not run the CROSSCHECK
Keywords and Parameters → listing the files or prompting for confirmation. The DELETE NOPROMPT command still displays each item … as it is deleted. By default, DELETE displays a list of files to be deleted and prompts for … command. If for some reason a backup or copy marked EXPIRED exists when you run the DELETE EXPIRED
DELETE → Specifies that the trigger for the program is a Delete event. A Delete event is a DELETE statement … for the object. Oracle OLAP executes the specified program immediately before a DELETE statement deletes the object.
Keywords and Parameters → Syntax Element Description GLOBAL Specifies that the script to delete is a global stored script … script named script_name and delete that script if it exists.) 'script_name' The name of the script … to delete. See Also: "CREATE SCRIPT", "EXECUTE SCRIPT", "REPLACE SCRIPT", and "LIST" for LIST SCRIPT NAMES.
Example → recovery catalog: rman TARGET / CATALOG rman/cat@catdb RMAN> DELETE SCRIPT b_whole_10; If a local stored
Restrictions and Usage Notes → Execute DELETE SCRIPT only at the RMAN prompt. RMAN must be connected to a recovery catalog and … target database, and the catalog database must be open. To delete a local script, you must be connected
DELETE Statement → The DELETE statement removes entire rows of data from a specified table or view. For a full … description of the DELETE statement, see Oracle Database SQL Reference. Syntax Description of the … Statement". table_reference A table or view, which must be accessible when you execute the DELETE … statement, and for which you must
Purpose → To delete a local or global stored script from the recovery catalog.
DELETE SCRIPT → Syntax deleteScript::= Text description of deleteScript
Using DBCA to Delete a Database → To delete a database using DBCA, select Delete a database from the Operations page. When you select
DELETE ALL → required name No No MAINTAIN DELETE ( not ALL) No required name Yes No MAINTAIN DELETE ALL No required … statement is deleting one or more properties, the literal DELETE. ( TEXT data type) When the value of … argument1 is DELETE, the name of the property or the literal ALL. In all other cases, the name of the
DELETE '$AGGREGATE_FROM' → Deletes the $AGGREGATE_FROM property. Examples Example 6-2 Using the $AGGREGATE_FROM Property Example 6-22, "Using a CACHE Statement in an Aggregation Specification" uses the following AGGREGATE command to aggregate the data. AGGREGATE sales_by_revenue USING revenue_aggmap FROM units_aggmap You can place a $AGGREGATE_FROM property on the sales_by_revenue variable by issuing the following statements.
MAINTAIN DELETE → The MAINTAIN command with the DELETE keyword deletes members from non-concat dimensions and … variables are dimensioned. Note: You can also issue a MAINTAIN DELETE statement for a surrogate … error. Syntax The syntax for using the DELETE keyword of the MAINTAIN command to delete members … following separate entries