CREATE TABLE TEST_TABLE
(
SESS_ID NUMBER,
MM NUMBER
)
PARTITION BY RANGE (SESS_ID)
(
PARTITION P_1 VALUES LESS THAN (2),
PARTITION P_2 VALUES LESS THAN (3)
)Table created.
insert into TEST_TABLE values (1,1)1 row(s) inserted.
insert into TEST_TABLE values (2,2)1 row(s) inserted.
commitStatement processed.
ALTER TABLE TEST_TABLE ADD (
CONSTRAINT PK_NOIDX_TST
PRIMARY KEY
(SESS_ID)
DISABLE VALIDATE)Table altered.
ALTER TABLE TEST_TABLE move partition P_1 ONLINEORA-25128: No insert/update/delete on table with constraint (SQL_HTMKHYEEMDVDJYHMQXLNLEQOQ.PK_NOIDX_TST) disabled and validatedMore Details: https://docs.oracle.com/error-help/db/ora-25128
select table_name, partition_name from user_tab_partitions where table_name = 'TEST_TABLE'| TABLE_NAME | PARTITION_NAME | TEST_TABLE | P_1 | TEST_TABLE | P_2 |
|---|
select object_name, subobject_name, object_type from user_objects where object_name = 'TEST_TABLE'| OBJECT_NAME | SUBOBJECT_NAME | OBJECT_TYPE | TEST_TABLE | - | TABLE | TEST_TABLE | P_1 | TABLE PARTITION | TEST_TABLE | P_2 | TABLE PARTITION | TEST_TABLE | SYS_P400979 | TABLE PARTITION |
|---|