3/ Basic Elements of Oracle SQL
alter table:
For语句指定分区即可不需要指定name
/5 Functions
For multilingual collations, for example GENERIC_M
/12 SQL语句:ALTER CLUSTER到ALTER JAVA
undrop_disk_clause: cancel the drop of disks from the disk group.c ancel the pending drop of all the disks in one or more disk groups
/13 SQL语句:ALTER LIBRARY到ALTER SYSTEM
13.2 ALTER MATERIALIZED VIEW:
刷新:快速刷新incremental refresh method 完整刷新 defining query
/14 SQL Statements: ALTER TABLE to ALTER TABLESPACE
14.1 alter table
(2)默认情况下,Oracle数据库压缩段,调整高水位标记,并立即释放恢复的空间。如果您的应用程序具有任何基于rowid的触发器,则应在发出此子句之前禁用它们。
(2)指定shrink_clause之前,不要对 index-organized 进行row movement ,因为rowid是主键
(4)compact仅进行segment碎片整理,并压缩,以供ALTER TABLE... SHRINK SPACE发布,不会重新调整高水位,并且不会立即释放空间,必须发出另一个 ALTER TABLE... SHRINK SPACE才能完成
/16 SQL语句:CREATE CLUSTER to CREATE JAVA
创建DISKGROUP
NORMAL REDUNDANCY要求存在至少两个故障组
HIGH REDUNDANCY要求存在至少三个故障组
EXTERNAL REDUNDANCY表示Oracle ASM不为磁盘组提供任何冗余;当用hardware mirroring or RAID时
CREATE FLASHBACK ARCHIVE: CREATE FLASHBACK ARCHIVE test_archive1 RETENTION 1 DAY; 这两个是必须的
/17 SQL Statements: CREATE LIBRARY to CREATE SPFILE
EXTERNALLY:must be authorized by an external service
/18 SQL语句:CREATE SYNONYM to CREATE TRIGGER
system_partitioning:不含任何partitioning key columns;Pruning follows the base table pruning rules
/20 SQL Statements: DROP SEQUENCE to ROLLBACK
DROP USER: 当您删除用户时,Oracle数据库还会从回收站清除所有该用户的模式对象。
ARCHIVELOG
mode(2)
must be mounted, but not open(2)语句:TO SCN;TO TIMESTAMP;TO RESTORE POINT
(3)ALTER DATABASE OPEN RESETLOGS
3/ Basic Elements of Oracle SQL
alter table:
For语句指定分区即可不需要指定name
/5 Functions
For multilingual collations, for example GENERIC_M
/12 SQL语句:ALTER CLUSTER到ALTER JAVA
undrop_disk_clause: cancel the drop of disks from the disk group.c ancel the pending drop of all the disks in one or more disk groups
/13 SQL语句:ALTER LIBRARY到ALTER SYSTEM
13.2 ALTER MATERIALIZED VIEW:
刷新:快速刷新incremental refresh method 完整刷新 defining query
/14 SQL Statements: ALTER TABLE to ALTER TABLESPACE
14.1 alter table
(2)默认情况下,Oracle数据库压缩段,调整高水位标记,并立即释放恢复的空间。如果您的应用程序具有任何基于rowid的触发器,则应在发出此子句之前禁用它们。
(2)指定shrink_clause之前,不要对 index-organized 进行row movement ,因为rowid是主键
(4)compact仅进行segment碎片整理,并压缩,以供ALTER TABLE... SHRINK SPACE发布,不会重新调整高水位,并且不会立即释放空间,必须发出另一个 ALTER TABLE... SHRINK SPACE才能完成
/16 SQL语句:CREATE CLUSTER to CREATE JAVA
创建DISKGROUP
NORMAL REDUNDANCY要求存在至少两个故障组
HIGH REDUNDANCY要求存在至少三个故障组
EXTERNAL REDUNDANCY表示Oracle ASM不为磁盘组提供任何冗余;当用hardware mirroring or RAID时
CREATE FLASHBACK ARCHIVE: CREATE FLASHBACK ARCHIVE test_archive1 RETENTION 1 DAY; 这两个是必须的
/17 SQL Statements: CREATE LIBRARY to CREATE SPFILE
EXTERNALLY:must be authorized by an external service
/18 SQL语句:CREATE SYNONYM to CREATE TRIGGER
system_partitioning:不含任何partitioning key columns;Pruning follows the base table pruning rules
/20 SQL Statements: DROP SEQUENCE to ROLLBACK
DROP USER: 当您删除用户时,Oracle数据库还会从回收站清除所有该用户的模式对象。
ARCHIVELOG
mode(2)
must be mounted, but not open(2)语句:TO SCN;TO TIMESTAMP;TO RESTORE POINT
(3)ALTER DATABASE OPEN RESETLOGS