ORA-25292: Buffer operations are not supported on the queue

Cause : Buffer operations are not supported on the specified queue type

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Buffered operations are only supported on to 8.1 style queues, which do not have transaction grouping.

update : 27-04-2017
ORA-25292

ORA-25292 - Buffer operations are not supported on the queue
ORA-25292 - Buffer operations are not supported on the queue

  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-24908 : invalid recipient presentation attribute
  • ora-09935 : Unlink of current password file failed.
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-12551 : TNS:missing keyword
  • ora-12422 : max policies exceeded
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-29307 : datafile string error, string
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-31521 : CDC subscription string already subscribes to publication ID string column string
  • ora-02098 : error parsing index-table reference (:I)
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-13844 : no new SQL profile name or category specified.
  • ora-13461 : the interleaving type is not supported
  • ora-02846 : Unkillable server
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-14042 : partition bound may not be specified for a partition being moved, modified or rebuilt
  • ora-16084 : an apply engine is already running
  • ora-30045 : No undo tablespace name specified
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-25263 : no message in queue string.string with message ID string
  • ora-32803 : value for string cannot be altered
  • ora-16801 : redo transport-related property is inconsistent with database setting
  • ora-24407 : connection pool already exists
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.