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博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1004711/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002861
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
