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
Examples → that the backup is complete, open the database. ALTER DATABASE OPEN; Mounting the Database After … to a recovery catalog, enter the following: STARTUP NOMOUNT; RESTORE CONTROLFILE; ALTER DATABASE … recovery RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS; # if the database uses locally-managed … control file SQL " ALTER
Restrictions on General Database Recovery → indicates cancel-based recovery. This clause recovers the database until you issue the ALTER
ALTER TRIGGER → Purpose Use the ALTER TRIGGER statement to enable, disable, or compile a database trigger. Note … own schema or you must have ALTER ANY TRIGGER system privilege. In addition, to alter a trigger on … ENABLE ALL TRIGGERS clause of ALTER TABLE to enable all triggers associated with a table. See ALTER
Restrictions on Dropping Constraints You cannot drop a primary key or unique key constraint that is… → alter_external_table_clauses Use the alter_external_table_clause to change the characteristics of an external table. This clause has no affect on the external data itself. The syntax and semantics of the parallel_clause, enable_disable_clause, external_data_properties, and REJECT LIMIT clause are the same as described for CREATE TABLE. See the external_table_clause (in CREATE TABLE ). PROJECT COLUMN
ALTER PACKAGE → Purpose Use the ALTER PACKAGE statement to explicitly recompile a package specification, body, or … stored as a unit, the ALTER PACKAGE statement recompiles all package objects together. You cannot use … the ALTER PROCEDURE statement or ALTER FUNCTION statement to recompile individually a procedure or … package
ALTER OUTLINE → Purpose Use the ALTER OUTLINE statement to rename a stored outline, reassign it to a different … have the ALTER ANY OUTLINE system privilege. Syntax alter_outline::= Description of the illustration … outline created under current conditions. ALTER OUTLINE salaries REBUILD;
Restrictions on Adding Columns → You cannot add a LOB column to a cluster table. If you add a LOB column to a hash-partitioned table, then the only attribute you can specify for the new partition is TABLESPACE. You cannot add a column with a NOT NULL constraint if table has any rows unless you also specify the DEFAULT clause. If you specify this clause for an index-organized table, then you cannot specify any other clauses in the
Restrictions on Adding List Partitions → In table_partition_description, you cannot specify partition_level_subpartition. You cannot add a list partition if you have already defined a DEFAULT partition for the table. Instead you must use the split_table_partition clause to split the DEFAULT partition. See Also: list_partitioning of CREATE TABLE for more information and restrictions on list partitions "Working with Default List Partitions:
Restrictions on Moving Tables → If you specify MOVE, then it must be the first clause in the ALTER TABLE statement, and the only … . To enable a single trigger, use the enable_clause of ALTER TRIGGER. See Also: CREATE TRIGGER … , ALTER TRIGGER, and "Enabling Triggers: Example" DISABLE ALL TRIGGERS Specify DISABLE ALL TRIGGERS to … queried it returns actual values
Restrictions on Records in a Block → CREATE TABLE and ALTER TABLE statements. For complete information on these clauses, please refer to … OVERFLOW, then the database raises an error and does not execute the ALTER TABLE statement. This checking
ALTER PROFILE → Purpose Use the ALTER PROFILE statement to add, modify, or remove a resource limit or password … management parameter in a profile. Changes made to a profile with an ALTER PROFILE statement affect … information on creating a profile Prerequisites You must have ALTER PROFILE system privilege to change … profile resource limits.
Notes on Exchanging Partitions and Subpartitions → Both tables involved in the exchange must have the same primary key, and no validated foreign keys can be referencing either of the tables unless the referenced table is empty. When exchanging between a partitioned table and the range partition of a composite-partitioned table: The partitioning key of the partitioned table must be identical to the subpartitioning key of the composite-partitioned table.
ALTER SESSION → Purpose Use the ALTER SESSION statement to set or modify any of the conditions or parameters that … database. Prerequisites To enable and disable the SQL trace facility, you must have ALTER SESSION … ALTER SESSION statements with the ADVISE clause in a single transaction. Each such statement sends … documentation for more information.
Session Parameters and ALTER SESSION → persists for the duration of the session or until you issue another ALTER SESSION SET CURRENT_SCHEMA … , or full level flagging. Once flagging is set in a session, a subsequent ALTER SESSION SET FLAGGER … : ALTER SESSION ENABLE PARALLEL DML; Forcing a Distributed Transaction: Example The following … local: ALTER
Semantics tablespace Specify the name of the tablespace to be altered. Restrictions on Altering Tablespaces → datafile or tempfile in smallfile tablespaces, use the ALTER DATABASE... autoextend_clause (see … Administrator's Guide for information on restarting the database without media recovery ALTER DATABASE "BACKUP … mode ALTER DATABASE alter_datafile_clause for information on taking individual datafiles out of online
Restrictions on Default Temporary Tablespaces → DATABASE and ALTER DATABASE statements. When used in with ALTER DATABASE, this clause resets the time … from being changed. You can override this setting for a current session using the ALTER SESSION … DISABLE GUARD statement. Please refer to ALTER SESSION for more information. ALL Specify ALL to prevent … in
ALTER JAVA → List Contents Index Master Index Feedback Previous Next View PDF ALTER JAVA Purpose Use the ALTER … class must be in your own schema, or you must have the ALTER ANY PROCEDURE system privilege. You must … invoker_rights_clause.gif Semantics JAVA SOURCE Use ALTER JAVA SOURCE to compile a Java source … schema object.
ALTER FUNCTION → Purpose Use the ALTER FUNCTION statement to recompile an invalid standalone stored function … -time compilation errors and performance overhead. The ALTER FUNCTION statement is similar to ALTER … . See CREATE FUNCTION. Prerequisites The function must be in your own schema or you must have ALTER … , you must set
See Also: "Recompiling a Type: Example" and "Recompiling a Type Specification: Example" → the ALTER SESSION or ALTER SYSTEM statement. If you omit any parameter from this clause and you … and ALTER TYPE statements. Please refer to inheritance_clauses in the documentation on CREATE TYPE … depend on the type. In one ALTER TYPE statement you can add or drop multiple methods, but you can … alter_attribute_definition
Restrictions on Nested Table Column Properties You cannot specify the parallel_clause. You cannot specify… → varray_col_properties The varray_col_properties clause lets you specify separate storage characteristics for the LOB in which a varray will be stored. If you specify this clause, then Oracle Database will always store the varray in a LOB, even if it is small enough to be stored inline. If varray_item is a multilevel collection, then the database stores all collection items nested within varray_item