ORA-31908
cannot modify the contents of a table with a staging log
Cause
An attempt was made to alter the contents of a table with a staging log.
Action
Do not use the following ALTER TABLE statements on a table with a staging log:
- ALTER TABLE EXCHANGE PARTITION
- ALTER TABLE DROP PARTITION
- ALTER TABLE TRUNCATE PARTITION
You must use the REGISTER_PARTITION_OPERATION procedure in the DBMS_SYNC_REFRESH package to perform these operations.
ORA-31908
cannot modify the contents of a table with a staging log
Cause
An attempt was made to alter the contents of a table with a staging log.
Action
Do not use the following ALTER TABLE statements on a table with a staging log:
- ALTER TABLE EXCHANGE PARTITION
- ALTER TABLE DROP PARTITION
- ALTER TABLE TRUNCATE PARTITION
You must use the REGISTER_PARTITION_OPERATION procedure in the DBMS_SYNC_REFRESH package to perform these operations.
ORA-31908
cannot modify the contents of a table with a staging log
Cause
An attempt was made to alter the contents of a table with a staging log.
Action
Do not use the following ALTER TABLE statements on a table with a staging log:
- ALTER TABLE EXCHANGE PARTITION
- ALTER TABLE DROP PARTITION
- ALTER TABLE TRUNCATE PARTITION
You must use the REGISTER_PARTITION_OPERATION procedure in the DBMS_SYNC_REFRESH package to perform these operations.
