Monthly Archives: June 2022
PARTITIONING
Adding partitions 11g/12c
-- SYNTAX :
ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME>
VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME > < UPDATE GLOBAL
INDEXES(optional)>;
-- NOTE: UPDATE GLOBAL...