Results for table


1 to 20 of 13418 results. Prev  Next
Results per page:   20  | 40 | 60


Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

2 Basic Components of Oracle Objects

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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

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

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…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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on List Subpartitioningthe list_values_clause, which is subject to the same requirements as at the table level. In the

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Notes on Composite PartitionsCREATE 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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on the Defining Query of a TableThe 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.

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on Hash Partitioning… list_partitioning Use the list_partitioning clause to partition the table on lists of literal values

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 … 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

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 … , 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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on List Partitioningamong 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.

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Notes on the parallel_clausereferential 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Altering External TablesYou 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

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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





Was this page helpful?

Integrated Cloud Applications & Platform Services