1,alter table shrink space compact cascade;对大表或大索引操作会产生大量日志 2,alter table shrink space;--加上compact选项仅重新整理segment 空间,并压缩表的记录在以后进行release空间.但数据库并不调整hwm及释放空间.为了释放空间.你必须再发布alter table shrink space --compact用于把一个长操作分割为两个...
Examine this command SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true? A. Queries and DML statements are allowed on ORDERs while the SHRINK is executing B.Dependent indexes become UNUSABLE B. C.The SHRINK operation causes rows to be moved to empty space starting ...
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACTWhich two statements are true A、 Queries and DML statements are allowed on ORDERs while the SHRINK is executingB、 Dependent indexes become UNUSABLEC、 The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERs...
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACTWhich two statements are true?A. The high-water mark (HWM) of ORDERS is adjusted. B. Only queries are allowed on ORDERS while the SHRINK is executing. C. Dependent indexes become UNUSABLE. D. The SHRINK operation causes rows to be moved to ...
在SQL中,删除索引的命令是:ALTER TABLEDROP P... 在SQL中,删除视图的命令是( )。 A.DROP VIEW 视图可以删除。删除视图的命令格式是:DROP VIEW。B是创建视图的命令。C是删除表文件的SQL命令。在SQL中,删除索引的命令是:ALTER TABLEDROP P... 牛股来了!9月27日重点关注这...
1,alter table shrink space compact cascade;对大表或大索引操作会产生大量日志 2,alter table shrink space;--加上compact选项仅重新整理segment 空间,并压缩表的记录在以后进行release空间.但数据库并不调整hwm及释放空间.为了释放空间.你必须再发布alter table shrink space ...
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?() AThe shrink operation touches every block in the BOOKING table BThe high-water mark (HWM) for the BOOKING table is shifted from its original ...
检查以下命令SQL> ALTER TABLE booking SHRINK SPACE COMPACT; 当以上命令被执行时哪一个操作将被执行A.收缩操作会触及BOOKING表中的每一个数据块B.会从原始的位置移动高水线CHWM)C.这一收缩操作的进度被存放在BOOKING表的位图块中D.BOOKING表上的数据维护语言 CDML) 触发器被执行,因为收缩操作内部是提供INSERT/...
compact:这个参数当系统的负载比较大时可以用,不降低HWM。如果系统负载较低时,直接用alter table table_name shrink space就一步到位了 cascade:这个参数是在shrink table的时候自动级联索引,相当于rebulid index。 普通表 shrink必须开启行迁移功能。 alter table table_name enable row movement ; ...