oracle临时表的限制: Restrictions: Temporary tables cannot be partitioned, index-organized, or clustered. You cannot specify any referential integrity (foreign key) constraints on temporary tables. Temporary tables cannot contain columns of nested table or varray type. You cannot specify the following clauses of the LOB_storage_clause: TABLESPACE, storage_clause, LOGGING or NOLOGGING, MONITORING or NOMONITORING, or LOB_index_clause. Parallel DML and parallel queries are not supported for temporary tables. (Parallel hints are ignored. Specification of the parallel_clause returns an error.) You cannot specify the segment_attributes_clause, nested_table_storage_clause, or parallel_clause. Distributed transactions are not supported for temporary tables.
oracle的临时表: 使用临时表空间的temporary segments,临时表的索引在创建临时表的时候不会分配任何index段。 创建语句CREATE GLOBAL TEMPORARY TABLE 具体的说明,见联机帮助。
Restrictions: Temporary tables cannot be partitioned, index-organized, or clustered. You cannot specify any referential integrity (foreign key) constraints on temporary tables. Temporary tables cannot contain columns of nested table or varray type. You cannot specify the following clauses of the LOB_storage_clause: TABLESPACE, storage_clause, LOGGING or NOLOGGING, MONITORING or NOMONITORING, or LOB_index_clause. Parallel DML and parallel queries are not supported for temporary tables. (Parallel hints are ignored. Specification of the parallel_clause returns an error.) You cannot specify the segment_attributes_clause, nested_table_storage_clause, or parallel_clause. Distributed transactions are not supported for temporary tables.
使用临时表空间的temporary segments,临时表的索引在创建临时表的时候不会分配任何index段。
创建语句CREATE GLOBAL TEMPORARY TABLE
具体的说明,见联机帮助。