tsingleeµÄÖíȦ

»¶Ó­À´µ½tsingleeµÄÖíȦ>>¡¡¡¡ | Ê×Ò³ ×ÊÔ´ÖÐÐÄ | Application | Unix | Oracle | Life | ITPUBÂÛ̳

Restrictions on Altering Temporary Tables

·¢±íÈË:tsinglee | ·¢±íʱ¼ä: 2008ÄêÎåÔÂ27ÈÕ, 17:16

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.

·¢±íÆÀÂÛ

±êÌâ

ÔÚ´ËÌí¼ÓÆÀÂÛ

³Æºô

ÓÊÏ䵨ַ£¨¿ÉÑ¡£©

¸öÈËÖ÷Ò³£¨¿ÉÑ¡£©


authimage



Valid XHTML 1.0 Strict and CSS. Powered by pLog
Design by Blog.lvwo.com