Cause: Not all of the conditions for the Queue of a STREAMS Apply process to be changeable were met. Conditions are: -The Apply process is not running. -The Apply process has no error. -The Apply process has no spilling. -The Apply process is a local Apply process. -The corresponding STREAMS Capture process should be stopped. See the solution below.
Error solution: Make sure all of the conditions are met.
Database version: Oracle 11g Release 2 (11.2)