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 ALTER


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


Recovery Manager Reference, 10g Release 1 (10.1)

ALTER DATABASE

Examplesthat 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

SQL Reference, 10g Release 1 (10.1)

ALTER DATABASE

Restrictions on General Database Recoveryindicates cancel-based recovery. This clause recovers the database until you issue the ALTER

SQL Reference, 10g Release 1 (10.1)

ALTER TRIGGER

ALTER TRIGGERPurpose 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

SQL Reference, 10g Release 1 (10.1)

ALTER PACKAGE

ALTER PACKAGEPurpose 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

SQL Reference, 10g Release 1 (10.1)

ALTER OUTLINE

ALTER OUTLINEPurpose 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;

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Adding ColumnsYou 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Adding List PartitionsIn 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:

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Moving TablesIf 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Records in a BlockCREATE 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

SQL Reference, 10g Release 1 (10.1)

ALTER PROFILE

ALTER PROFILEPurpose 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.

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Notes on Exchanging Partitions and SubpartitionsBoth 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.

SQL Reference, 10g Release 1 (10.1)

ALTER SESSION

ALTER SESSIONPurpose 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.

SQL Reference, 10g Release 1 (10.1)

ALTER SESSION

Session Parameters and ALTER SESSIONpersists 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLESPACE

Semantics tablespace Specify the name of the tablespace to be altered. Restrictions on Altering Tablespacesdatafile 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

SQL Reference, 10g Release 1 (10.1)

ALTER DATABASE

Restrictions on Default Temporary TablespacesDATABASE 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

SQL Reference, 10g Release 1 (10.1)

ALTER JAVA

ALTER JAVAList 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.

SQL Reference, 10g Release 1 (10.1)

ALTER FUNCTION

ALTER FUNCTIONPurpose 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

SQL Reference, 10g Release 1 (10.1)

ALTER TYPE

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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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