Database Error Messages

OCI-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.