How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
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
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
Using DELETE → You can delete the rows of a table using the DELETE statement. For example, the following statement … deletes all rows from the emp table: DELETE FROM emp; If there are many rows present in a table or … cluster when using the DELETE statement, significant system resources are consumed as the rows are … DELETE