You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for DROP


1 to 60 of 2673 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

DROP INDEX

17.5 DROP INDEXSyntax DROP INDEX [schema.]index [FORCE]; Purpose Deletes a spatial index. Keywords and Parameters … privileges on the index type and its implementation type. Usage Notes Use DROP INDEX indexname FORCE … -process or an error occurs. DROP INDEX oldindex FORCE; Related Topics CREATE INDEX

Database Backup and Recovery Reference, 12c Release 1 (12.1)

DROP CATALOG

DROP CATALOGPurpose Use the DROP CATALOG command to remove the recovery catalog or a virtual private catalog … . See Also: Oracle Database Backup and Recovery User's Guide to learn how to drop the recovery catalog … target database. Usage Notes After you execute DROP CATALOG, RMAN prompts you to enter the command … CATALOG, whereas a virtual

Database Backup and Recovery Reference, 12c Release 1 (12.1)

DROP DATABASE

DROP DATABASEPurpose Use the DROP DATABASE command to delete the target database and, if RMAN is connected to a … a recovery catalog but run RMAN in NOCATALOG mode when you drop the database, then RMAN does not … database: TEST1 (DBID=39525561) RMAN> STARTUP FORCE MOUNT RMAN> ALTER SYSTEM ENABLE RESTRICTED SESSION; RMAN> DROP DATABASE INCLUDING BACKUPS

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing Flashback and Database Point-in-Time Recovery

Prerequisites of Flashback DropDrop and the recycle bin: DROP Any user with DROP privileges over an object can drop the object … , placing it in the recycle bin. FLASHBACK TABLE... TO BEFORE DROP Privileges for this statement are … tied to the privileges for DROP. That is, any user who can drop an

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing Flashback and Database Point-in-Time Recovery

About Flashback DropFlashback Drop reverses the effects of a DROP TABLE operation. Flashback Drop is faster than other … lead to downtime or loss of recent transactions. When you drop a table, the database does not … the original user-specified name of the table or the system-generated name. When you drop a table

Text Reference, 12c Release 1 (12.1)

Oracle Text Utilities

-dropDrop the user dictionary currently associated with an entity extraction policy.

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing Flashback and Database Point-in-Time Recovery

Rewinding a DROP TABLE Operation with Flashback Dropa simple Flashback Table scenario Rewinding a DROP TABLE Operation with Flashback Drop This section … explains how to retrieve objects from the recycle bin with the FLASHBACK TABLE... TO BEFORE DROP … statement. This section contains the following topics: About Flashback Drop Prerequisites of Flashback Drop

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Performing Flashback and Database Point-in-Time Recovery

Performing a Flashback Drop OperationUse the FLASHBACK TABLE... TO BEFORE DROP statement to recover objects from the recycle bin. You … assumes a scenario in which you drop the wrong table. Many times you have been asked to drop tables … and drop hr.employee_demo. You decide to use FLASHBACK TABLE to retrieve the dropped object. To … retrieve a dropped

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Schema Objects

18.3.2 Using DROP and CREATE to Truncate a TableYou can drop a table and then re-create the table to truncate it. For example, the following … statements drop and then re-create the emp table: DROP TABLE emp; CREATE TABLE emp (... ); When dropping

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.11 Using Flashback Drop and Managing the Recycle BinWhen you drop a table, the database does not immediately remove the space associated with the table … Flashback Drop, and the FLASHBACK TABLE statement is used to restore the table. Before discussing the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2.5 Drop Indexes That Are No Longer RequiredIt is best practice to drop indexes that are no longer required. Consider dropping an index if: It

Database Administrator's Guide, 12c Release 1 (12.1)

Using Oracle Managed Files

You can create, back up, and drop control files.17.3.3.1 Specifying Control Files at Database Creation At database creation, the control file is created in the files specified by the CONTROL_FILES initialization parameter. If the CONTROL_FILES parameter is not set and at least one of the initialization parameters required for the creation of Oracle Managed Files is set, then an Oracle managed control file is created in the default control file

Database Reference, 12c Release 1 (12.1)

gcs remastering wait for drop pkey

C.3.59 gcs remastering wait for drop pkeyA session dropping an object waits on the lock manager daemon (LMD) to remove the object's affinity to an instance. Wait Time: 20 hundredths of a second Parameter Description pkey The object id of the database object being dropped

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Commands: A-G

DROP AGGOUNTtracking, see \"NA2 Bits and Null Tracking\". DROP NULLTRACKING Removes NA2 bits to the specified

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Commands: A-G

DROP DIMENSIONWithin an aggregation specification, a DROP DIMENSION statement specifies how non-hierarchical … to populate the target variable. Syntax DROP DIMENSION dimname [VALUES { valsetname |ALL}  OPERATOR

SQL Developer User's Guide, 12c Release 1 (12.1)

SQL Developer Dialog Boxes and Wizards

5.14 Confirm Drop ApplicationDrop. To drop the application, click Yes. to keep (not drop) the application, click No. If the

R Enterprise User's Guide for Linux, Solaris, AIX, and Windows, 12c Release 1 (12.1)

Using Oracle R Enterprise

Drop a Database TableTo drop a table in the database use ore.drop(table=\"NAMEOFTABLE\") For example, this command drops DF_TABLE: ore.drop(table=\"DF_TABLE\")

Text Reference, 12c Release 1 (12.1)

Oracle Text SQL Statements and Operators

1.6 DROP INDEXNote: This section describes the DROP INDEX statement as it pertains to dropping a Text domain … index. For a complete description of the DROP INDEX statement, see Oracle Database SQL Language … Reference. Purpose Use DROP INDEX to drop a specified Text index. Syntax DROP INDEX [schema.]index [force];

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Privileges Required to Create, Modify, or Drop a Common RoleCommon users must have common privileges in order to create, modify, or drop common roles. Only … common users who have the commonly granted CREATE ROLE, ALTER ROLE, and DROP ROLE privileges can create … , alter, or drop common roles. Common users can create local roles, too, but these roles are available only in the PDB in which they

Application Express Release Notes, 12c Release 1 (12.1)

Oracle® Application Express Release Notes

4.17 Drag and Drop Layout Page RemovedThe Drag and Drop icon that previously displayed on the Page Definition in Component View and the … Drag and Drop Layout page have been removed from Oracle Application Express release 4.2.

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Type and DDL Support on a Logical Standby Database

PROFILE ALTER PROFILE CREATE PROFILE DROP PROFILECREATE PACKAGE CREATE PACKAGE BODY CREATE PROCEDURE DROP FUNCTION DROP LIBRARY DROP PACKAGE DROP PACKAGE … BODY DROP PROCEDURE PROFILE ALTER PROFILE CREATE PROFILE DROP PROFILE PUBLIC DATABASE LINK CREATE … PUBLIC DATABASE LINK DROP PUBLIC DATABASE LINK PUBLIC SYNONYM

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Clusters

22.5 Dropping Clusters and Objects That Use ThemYou drop a cluster using the DROP CLUSTER statement. You drop a clustered table using the DROP … TABLE statement. You drop a cluster index using the DROP INDEX statement.

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Dropping Templates from a Disk Group

Dropping Templates from a Disk GroupUse the DROP TEMPLATE clause of the ALTER DISKGROUP statement to drop one or more templates from a … disk group. You can only drop templates that are user-defined; you cannot drop system default … a template from a disk group ALTER DISKGROUP data DROP TEMPLATE unreliable;

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Managing Disk Group Directories

Dropping a DirectoryYou can delete a directory using the DROP DIRECTORY clause of the ALTER DISKGROUP statement. You … cannot drop a system-created directory. You cannot drop a directory containing alias names unless you … -13 Dropping a directory ALTER DISKGROUP data DROP DIRECTORY '+data/yourdir' FORCE;

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Views, Sequences, and Synonyms

24.1.7 Dropping ViewsYou can drop a view with the DROP VIEW statement. You can drop any view contained in your schema … . To drop a view in another user's schema, you must have the DROP ANY VIEW system privilege. Drop a … view using the DROP VIEW statement. For example, the following statement

Database SQL Language Reference, 12c Release 1 (12.1)

DROP VIEW

DROP VIEWPurpose Use the DROP VIEW statement to remove a view or an object view from the database. You can … or you must have the DROP ANY VIEW system privilege. Syntax drop_view::= Description of the … dropped. Oracle Database does not drop views, materialized views, and synonyms that are dependent … on the view but marks them INVALID.

Database SQL Language Reference, 12c Release 1 (12.1)

DROP FUNCTION

DROP FUNCTIONcomplete information on creating, altering, and dropping functions. Use the DROP FUNCTION statement … a function that is part of a package. Instead, either drop the entire package using the DROP PACKAGE … OR REPLACE clause. Prerequisites The function must be in your own schema or you must have the DROP … SecondMax:

Database SQL Language Reference, 12c Release 1 (12.1)

DROP PACKAGE

DROP PACKAGEcomplete information on creating, altering, and dropping packages. Use the DROP PACKAGE statement to … REPLACE clause. Prerequisites The package must be in your own schema or you must have the DROP ANY … ''drop_package.gif'' Semantics BODY Specify BODY to drop only the body of the package. If you omit this clause, then … Oracle

Database SQL Language Reference, 12c Release 1 (12.1)

DROP SEQUENCE

DROP SEQUENCEPurpose Use the DROP SEQUENCE statement to remove a sequence from the database. You can also use … , then you can drop the sequence and then re-create it with the same name and a START WITH value of 27 … sequence Prerequisites The sequence must be in your own schema or you must have the DROP ANY SEQUENCE … , you must either be

Database SQL Language Reference, 12c Release 1 (12.1)

DROP JAVA

DROP JAVAGo to main content 475/555 DROP JAVA Purpose Use the DROP JAVA statement to drop a Java source … the DROP ANY PROCEDURE system privilege. You also must have the EXECUTE object privilege on Java … illustration ''drop_java.gif'' Semantics JAVA SOURCE Specify SOURCE to drop a Java source schema

Database SQL Language Reference, 12c Release 1 (12.1)

DROP DISKGROUP

DROP DISKGROUPStorage Management Administrator's Guide. Purpose The DROP DISKGROUP statement lets you drop an Oracle … ''drop_diskgroup.gif'' Semantics diskgroup_name Specify the name of the disk group you want to drop … . INCLUDING CONTENTS Specify INCLUDING CONTENTS to confirm that Oracle ASM should drop all the files … disk

Database SQL Language Reference, 12c Release 1 (12.1)

DROP SYNONYM

DROP SYNONYMPurpose Use the DROP SYNONYM statement to remove a synonym from the database or to change the … synonyms Prerequisites To drop a private synonym, either the synonym must be in your own schema or … you must have the DROP ANY SYNONYM system privilege. To drop a PUBLIC synonym, you must have the DROP

Database SQL Language Reference, 12c Release 1 (12.1)

DROP DIRECTORY

DROP DIRECTORYPurpose Use the DROP DIRECTORY statement to remove a directory object from the database. See Also … : CREATE DIRECTORY for information on creating a directory Prerequisites To drop a directory, you must … have the DROP ANY DIRECTORY system privilege. Caution: Do not drop a directory when files in the … Directory:

Database SQL Language Reference, 12c Release 1 (12.1)

DROP TABLESPACE

DROP TABLESPACEPurpose Use the DROP TABLESPACE statement to remove a tablespace from the database. When you drop a … information on creating and modifying a tablespace Prerequisites You must have the DROP TABLESPACE system … privilege. You cannot drop a tablespace if it contains any rollback segments holding active … tablespace

Database SQL Language Reference, 12c Release 1 (12.1)

DROP OUTLINE

DROP OUTLINEstored outlines are marked as migrated and can be removed. You can drop all migrated stored outlines … Database PL/SQL Packages and Types Reference for information about the DBMS_SPM package Use the DROP … OUTLINE statement to drop a stored outline. See Also: CREATE OUTLINE for information on creating an … outline Prerequisites

Database SQL Language Reference, 12c Release 1 (12.1)

DROP PROFILE

DROP PROFILEPurpose Use the DROP PROFILE statement to remove a profile from the database. You can drop any … a profile Prerequisites You must have the DROP PROFILE system privilege. Syntax drop_profile … clause to drop a profile that is currently assigned to users. Examples Dropping a Profile: Example … currently assigned

Database SQL Language Reference, 12c Release 1 (12.1)

DROP CONTEXT

DROP CONTEXTPurpose Use the DROP CONTEXT statement to remove a context namespace from the database. Removing a … Prerequisites You must have the DROP ANY CONTEXT system privilege. Syntax drop_context::= Description of the … drop. You cannot drop the built-in namespace USERENV. See Also: SYS_CONTEXT for information on the

Database SQL Language Reference, 12c Release 1 (12.1)

DROP DATABASE

DROP DATABASEPurpose Caution: You cannot roll back a DROP DATABASE statement. Use the DROP DATABASE statement to … drop the database. This statement is useful when you want to drop a test database or drop an old

Database SQL Language Reference, 12c Release 1 (12.1)

DROP USER

DROP USERPurpose Use the DROP USER statement to remove a database user and optionally remove the user's … of the current node. When you drop a user, Oracle Database also purges all of that user's schema … objects from the recycle bin. Caution: Do not attempt to drop the users SYS or SYSTEM. Doing so will … a user Prerequisites You must

Database SQL Language Reference, 12c Release 1 (12.1)

DROP ROLE

DROP ROLEPurpose Use the DROP ROLE statement to remove a role from the database. When you drop a role … ADMIN OPTION or you must have the DROP ANY ROLE system privilege. Syntax drop_role::= Description … . Examples Dropping a Role: Example  To drop the role dw_manager, which was created in \"Creating a Role … : Example\",

Database SQL Language Reference, 12c Release 1 (12.1)

DROP DIMENSION

DROP DIMENSIONPurpose Use the DROP DIMENSION statement to remove the named dimension. This statement does not … The dimension must be in your own schema or you must have the DROP ANY DIMENSION system privilege … of the dimension you want to drop. The dimension must already exist. Examples Dropping a Dimension … : Example  This example drops

Database SQL Language Reference, 12c Release 1 (12.1)

DROP LIBRARY

DROP LIBRARYPurpose Use the DROP LIBRARY statement to remove an external procedure library from the database … . See Also: CREATE LIBRARY for information on creating a library Prerequisites You must have the DROP … . Examples Dropping a Library: Example  The following statement drops the ext_lib library: DROP LIBRARY ext_lib;

Database SQL Language Reference, 12c Release 1 (12.1)

DROP TYPE

DROP TYPEfor complete information on creating, altering, and dropping object types. Use the DROP TYPE … statement to drop the specification and body of an object type, a varray, or a nested table type … DROP ANY TYPE system privilege. Syntax drop_type::= Description of the illustration ''drop_type.gif … table type to be dropped. You can

Database SQL Language Reference, 12c Release 1 (12.1)

DROP OPERATOR

DROP OPERATORPurpose Use the DROP OPERATOR statement to drop a user-defined operator. See Also: CREATE OPERATOR … operator must be in your schema or you must have the DROP ANY OPERATOR system privilege. Syntax … own schema. operator Specify the name of the operator to be dropped. FORCE Specify FORCE to drop the … . Without

Database SQL Language Reference, 12c Release 1 (12.1)

DROP EDITION

DROP EDITIONPurpose Use the DROP EDITION statement to drop an edition, along with all actual editionable … You must have the DROP ANY EDITION system privilege, granted either directly or through a role … objects that are inherited by a child edition, even if you specify CASCADE. DROP EDITION will fail if … you attempt to

Database SQL Language Reference, 12c Release 1 (12.1)

DROP INDEX

DROP INDEXPurpose Use the DROP INDEX statement to remove an index or domain index from the database. When you … drop a global partitioned index, a range-partitioned index, or a hash-partitioned index, all the … index partitions are also dropped. If you drop a composite-partitioned index, then all the index … partitions and subpartitions

Database SQL Language Reference, 12c Release 1 (12.1)

DROP TRIGGER

DROP TRIGGERcomplete information on creating, altering, and dropping triggers. Use the DROP TRIGGER statement to … Prerequisites The trigger must be in your own schema or you must have the DROP ANY TRIGGER system privilege. To … drop a trigger on DATABASE in another user's schema, you must also have the ADMINISTER DATABASE … : Example  The

Database SQL Language Reference, 12c Release 1 (12.1)

DROP TABLE

DROP TABLEPurpose Use the DROP TABLE statement to move a table or object table to the recycle bin or to … clause, the DROP TABLE statement does not result in space being released back to the tablespace for use … data, which resides outside of the database. When you drop a table that is part of a cluster, the … table is moved to the recycle

Database SQL Language Reference, 12c Release 1 (12.1)

DROP INDEXTYPE

DROP INDEXTYPEPurpose Use the DROP INDEXTYPE statement to drop an indextype as well as any association with a … indextype must be in your own schema or you must have the DROP ANY INDEXTYPE system privilege. Syntax … Specify FORCE to drop the indextype even if the indextype is currently being referenced by one or … more domain

Database SQL Language Reference, 12c Release 1 (12.1)

DROP CLUSTER

DROP CLUSTERPurpose Use the DROP CLUSTER clause to remove a cluster from the database. Caution: When you drop a … contents as the old one, but with no CLUSTER clause. Drop the old table. Use the RENAME statement to … on the old clustered table do not apply. See Also: CREATE TABLE, DROP TABLE, RENAME, GRANT for … information

Database SQL Language Reference, 12c Release 1 (12.1)

DROP PROCEDURE

DROP PROCEDUREcomplete information on creating, altering, and dropping procedures. Use the DROP PROCEDURE … procedure that is part of a package. Instead, either drop the entire package using the DROP PACKAGE … OR REPLACE clause. Prerequisites The procedure must be in your own schema or you must have the DROP … procedure to

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing Physical and Snapshot Standby Databases

10.3.5 Add or Drop a Redo Log File Group… Take the following steps to add or drop a log file group or standby log file group on a physical … AUTO, change the value to MANUAL. Add or drop a log file group. Note: An online logfile group must

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Migrating Advanced Replication to Oracle Streams

Step 1   Drop Replication Groups You Migrated at Each SiteTo drop a replication group that you successfully migrated to Oracle Streams, connect as the … need the replication administrator, then you can drop this user also. Caution: Do not resume any

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Views, Sequences, and Synonyms

24.3.4 Dropping SynonymsDrop a synonym that is no longer required using DROP SYNONYM statement. To drop a private synonym … , omit the PUBLIC keyword. To drop a public synonym, include the PUBLIC keyword. You can drop any … private synonym in your own schema. To drop a private synonym in another user's schema,

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Hash Clusters

23.5 Dropping Hash ClustersYou can drop a hash cluster using the DROP CLUSTER statement. For example, the following DROP … CLUSTER statement drops the emp_dept cluster: DROP CLUSTER emp_dept; A table in a hash cluster is dropped … using the DROP TABLE statement. The implications of dropping hash clusters and tables in hash

TimesTen In-Memory Database SQL Reference, 12c Release 1 (12.1)

SQL Statements

DROP INDEXThe DROP INDEX statement removes the specified index. Required privilege No privilege is required … for the index owner. DROP ANY INDEX for another user's index. SQL syntax DROP INDEX [Owner.]IndexName … .] TableName Name of the table upon which the index was created. Description If you attempt to drop a \"busy

TimesTen In-Memory Database SQL Reference, 12c Release 1 (12.1)

SQL Statements

DROP PROCEDUREThe DROP PROCEDURE statement removes a standalone stored procedure from the database. Do not use … required for the procedure owner. DROP ANY PROCEDURE for another user's procedure. SQL syntax DROP … procedure to be dropped. Description When you drop a procedure, TimesTen invalidates objects that … . Do not use

TimesTen In-Memory Database SQL Reference, 12c Release 1 (12.1)

SQL Statements

DROP SYNONYMThe DROP SYNONYM statement removes a synonym from the database. If the synonym is replicated across … an active standby pair and if DDL_REPLICATION_LEVEL is 2 or greater, the DROP SYNONYM statement … Guide for more information. Required privilege No privilege is required to drop the private synonym by … its owner. The DROP

TimesTen In-Memory Database SQL Reference, 12c Release 1 (12.1)

SQL Statements

DROP REPLICATIONThe DROP REPLICATION statement destroys a classic replication scheme and removes it from the … executing database. Required privilege ADMIN SQL syntax DROP REPLICATION [Owner.]ReplicationSchemeName … replication scheme, r: DROP REPLICATION r; See also ALTER REPLICATION CREATE REPLICATION

TimesTen In-Memory Database SQL Reference, 12c Release 1 (12.1)

SQL Statements

DROP FUNCTIONThe DROP FUNCTION statement removes a standalone stored function from the database. Do not use this … required for the function owner. DROP ANY PROCEDURE for another user's function. SQL syntax DROP FUNCTION … to be dropped. Description When you drop a function, TimesTen invalidates objects that depend on the