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
TABLE() → Table functions are functions that produce a collection of rows, a nested table or a varray, that … can be queried like a physical database table or assigned to a PL/SQL collection variable. You can … use a table function like the name of a database table, in the FROM clause of a query, or like a
Restrictions on Temporary Tables Temporary tables cannot be partitioned, clustered, or index organized.… → relational_properties The relational properties describe the components of a relational table … . column Specify the name of a column of the table. If you also specify AS subquery, then you can omit … column and datatype unless you are creating an index-organized table. If you specify AS subquery when … creating an index-organized
Restrictions on Dropping Constraints You cannot drop a primary key or unique key constraint that is… → an external table. This clause has no affect on the external data itself. The syntax and semantics of … the same as described for CREATE TABLE. See the external_table_clause (in CREATE TABLE ). PROJECT … table in subsequent queries. The default is PROJECT COLUMN REFERENCED, which means that the access … than the
Restrictions on List Subpartitioning → the list_values_clause, which is subject to the same requirements as at the table level. In the
Notes on Composite Partitions → CREATE TABLE statement, NOCACHE is the default In an ALTER TABLE statement, the existing value is not … for this table are placed at the most recently used end of the least recently used (LRU) list in the … buffer cache when a full table scan is performed. This attribute is useful for small lookup tables … -organized
Restrictions on the Defining Query of a Table → The number of columns in the table must equal the number of expressions in the subquery. The column … . You cannot define a foreign key constraint in a CREATE TABLE statement that contains AS subquery … . Instead, you must create the table without the constraint and then add it later with an ALTER TABLE … statement.
Restrictions on Hash Partitioning → … list_partitioning Use the list_partitioning clause to partition the table on lists of literal values
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 … 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 … statement
Restrictions on Adding List Partitions → list partition if you have already defined a DEFAULT partition for the table. Instead you must use … TABLE for more information and restrictions on list partitions "Working with Default List … value. Restriction on Coalescing Table Partitions If you update global indexes using the … partitioned table. If you want
Restrictions on Moving Tables → If you specify MOVE, then it must be the first clause in the ALTER TABLE statement, and the only … , and the LOB_storage_clause. You cannot move a table containing a LONG or LONG RAW column. You cannot … MOVE an entire partitioned table (either heap or index organized). You must move individual … segments, even if you do not specify
Restrictions on List Partitioning → among all partitions of table. composite_partitioning Use the composite_partitioning clause to first … partition table by range, and then partition the partitions further into hash or list subpartitions … Partitioning You cannot specify composite partitioning for an index-organized table. Therefore, the … composite partitioning.
Restrictions on Records in a Block → table. You must first drop the bitmap index. You cannot specify this clause for an index-organized table … or a nested table. MINIMIZE Specify MINIMIZE to instruct Oracle Database to calculate the largest … number of records in any block in the table and to limit future inserts so that no block can contain … in
Notes on Exchanging Partitions and Subpartitions → 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.
Restrictions on Nested Table Column Properties You cannot specify the parallel_clause. You cannot specify… → defaults to the tablespace of the containing table. LOB_storage_clause Use the LOB_storage_clause to … different from those of the table. For LOB_segname, specify the name of the LOB data segment. You cannot … when moving the table ( move_table_clause ). CHUNK integer Specify the number of bytes to be
Restrictions on Dropping Columns Each of the parts of this clause can be specified only once in the… → rename_column_clause Use the rename_column_clause to rename a column of table. The new column name … must not be the same as any other column name in table. When you rename a column, Oracle Database
Notes on the parallel_clause → referential integrity constraint. If you define a bitmap index on table, then: If table is nonpartitioned … , then subsequent DML operations are executed serially. If table is partitioned, then the database … limits the degree of parallelism to the number of partitions accessed in the DML operation. If table
Restrictions on Altering External Tables → You cannot modify an external table using any clause outside of this clause. You cannot add a LONG … , varray, or object type column to an external table, nor can you change the datatype of an external … table column to any of these datatypes. You cannot add a constraint to an external table. You cannot … modify
Restrictions on External Tables An external table cannot be a temporary table. You cannot specify constraints… → driver for this external table. The opaque_format_spec lets you list the parameters and their values … opaque_format_spec. Field names specified in the opaque_format_spec must match columns in the table … the table definition. USING CLOB subquery lets you derive the parameters and their values through a … . CLUSTER Clause The
Restrictions on Moving Table Partitions If partition is a hash partition, then the only attribute you… → high end of a partitioned table (after the last existing partition). You can specify any create … -time physical attributes for the new partition. If the table contains LOB columns, then you can also … composite-partitioned table and do not describe the subpartitions, then the database assigns subpartition … names as described
Restrictions on Dropping Table Partitions You cannot drop a partition of a hash-partitioned table. Instead,… → -partitioned table. Oracle Database deletes any rows in the dropped subpartition. Oracle Database drops