本文详细介绍了在使用临时表时的各项限制条件，包括但不限于不能添加嵌套表类型字段、无法指定新增或修改字段的参照完整性约束等。对于希望深入了解临时表特性的数据库开发者来说，本文提供了宝贵的指导。
You can modify, drop columns from, or
rename a temporary table. However, for a temporary table you cannot:
■ Add columns of nested table type. You can add columns of other types.
■ Specify referential integrity (foreign key) constraints for an added or modified
column.
■ Specify the following clauses of the LOB_storage_clause for an added or
modified LOB column: TABLESPACE, storage_clause, logging_clause,
allocate_extent_clause, or deallocate_unused_clause.
■ Specify the physical_attributes_clause, nested_table_col_
properties, parallel_clause, allocate_extent_clause, deallocate_
unused_clause, or any of the index-organized table clauses.
■ Exchange partitions between a partition and a temporary table.
■ Specify the logging_clause.
■ Specify MOVE.[@more@]
rename a temporary table. However, for a temporary table you cannot:
■ Add columns of nested table type. You can add columns of other types.
■ Specify referential integrity (foreign key) constraints for an added or modified
column.
■ Specify the following clauses of the LOB_storage_clause for an added or
modified LOB column: TABLESPACE, storage_clause, logging_clause,
allocate_extent_clause, or deallocate_unused_clause.
■ Specify the physical_attributes_clause, nested_table_col_
properties, parallel_clause, allocate_extent_clause, deallocate_
unused_clause, or any of the index-organized table clauses.
■ Exchange partitions between a partition and a temporary table.
■ Specify the logging_clause.
■ Specify MOVE.[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1004711/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-1004711/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
