add_table_partition、modify_table_partition、move_table_partitionおよびsplit_table_partition句を使用する場合、領域を確保する表領域に領域割当て制限が必要です。 パーティション化操作が子の参照パーティション表にカスケードする場合、子の参照パーティション表では権限は必要ありません。 制約およ...
如果系统负载较低时,直接用alter table table_name shrink space就一步到位了 cascade:这个参数是在shrink table的时候自动级联索引,相当于rebulid index。 普通表 shrink必须开启行迁移功能。 alter table table_name enable row movement ; 保持HWM,相当于把块中数据打结实了 alter table table_name shrink space ...
(modify_LOB_parameters) }...|[ REBUILD ] UNUSABLELOCALINDEXES|{ADD|DROP}VALUES( list_values )|read_only_clause|indexing_clause } move_table_partition: MOVE partition_extended_name [ MAPPINGTABLE] [ table_partition_description ] [ filter_condition] [ update_index_clauses ] [ parallel_clause ...
openGauss=# \helpAvailable help:ABORT ALTER TABLE CREATE DATABASE CREATE TEXT SEARCH CONFIGURATION DROP OPERATOR MERGE ALTER APP WORKLOAD GROUP ALTER TABLE PARTITION CREATE DIRECTORY CREATE TEXT SEARCH DICTIONARY DROP OWNED MOVE ALTER APP WORKLOAD GROUP MAPPING ALTER TABLESPACE CREATE Extension CREATE TRI...
ALTER privilege on the table to be altered CONTROL privilege on the table to be altered ALTERIN privilege on the schema of the table DBADM authority To create or drop a foreign key, the privileges that are held by the authorization ID of the statement must include one of the following autho...
Bind a node group to the hash bucket table to determine the bucket mapping. ALTERDATABASEdatabase_nameTOGROUPgroup_name; Migrate a specified bucket from one DN to another. ALTERDATABASEdatabase_nameMOVEBUCKETS(bucketlist)FROMdatanode_nameTOdatanode_name; ...
With thetable shrinkingfeature we can get Oracle to move rows which are located in the middle or at the end of a segment further more down to the beginning of the segment and by this make the segment more compact. For this we must first allow ORACLE to change the ROWIDs of these rows...
1 When adding a column to an HBase table, hbase-column-mapping is required. 2 Db2 Big SQL 7.2 and later service This feature requires the Db2 Big SQL 7.2 and later service on IBM Cloud Pak® for Data 4.0 and later. Description table-name The table-name must identify an existing Hado...
ALTER APP WORKLOAD GROUP MAPPING ALTER AUDIT POLICY ALTER COORDINATOR ALTER DATABASE ALTER DATABASE LINK ALTER DATA SOURCE ALTER DEFAULT PRIVILEGES ALTER DIRECTORY ALTER FOREIGN TABLE (导入导出) ALTER FUNCTION ALTER GLOBAL CONFIGURATION ALTER GROUP ...
ORA-14133 ALTER TABLE MOVE cannot be combined with other operations ORA-14169 invalid ALTER TABLE MODIFY SUBPARTITION option ORA-14171 cannot specify subpartition_description clause in CREATE|ALTER TABLE ORA-14172 invalid ALTER TABLE EXCHANGE SUBPARTITION option ...