Results for DELETE


1 to 20 of 2041 results. Prev  Next
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

DELETE

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.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

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

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

Restrictions and Usage NotesThe 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

SQL Reference, 10g Release 1 (10.1)

DELETE

Restrictions on the DML_table_expression Clausesubquery 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

SQL Reference, 10g Release 1 (10.1)

DELETE

DELETEPurpose 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

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

DELETESyntax delete::= Text description of delete maintSpec::= Text description of maintSpec

DML Reference, 10g Release 1 (10.1)

DELETE

DELETEThe 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

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

PurposeTo 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

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

Keywords and Parameterslisting 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETESpecifies 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.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Keywords and ParametersSyntax 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.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Examplerecovery catalog: rman TARGET / CATALOG rman/cat@catdb RMAN> DELETE SCRIPT b_whole_10; If a local stored

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Restrictions and Usage NotesExecute 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

User's Guide and Reference, 10g Release 1 (10.1)

DELETE Statement

DELETE StatementThe 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

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

PurposeTo delete a local or global stored script from the recovery catalog.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

DELETE SCRIPTSyntax deleteScript::= Text description of deleteScript

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Using DBCA to Delete a DatabaseTo delete a database using DBCA, select Delete a database from the Operations page. When you select

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETE ALLrequired 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

DML Reference, 10g Release 1 (10.1)

$AGGREGATE_FROM

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.

DML Reference, 10g Release 1 (10.1)

MAINTAIN

MAINTAIN DELETEThe 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


Was this page helpful?