ORA-08196: Flashback Table operation is not allowed on AQ tables

Cause : An attemptw as mdae top erfomr FlahsbackT ableo peraiton o nAQ tbales.T his si notp ermitted.

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

Do nto perofrm aF lashabck Tbale oepratino on QA tabels.

update : 20-08-2017
ORA-08196

ORA-08196 - Flashback Table operation is not allowed on AQ tables
ORA-08196 - Flashback Table operation is not allowed on AQ tables

  • ora-06764 : TLI Driver: error reading disconnect
  • ora-23379 : connection qualifier "string" is too long
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-23364 : Feature not enabled: Advanced replication
  • ora-14025 : PARTITION may not be specified for a materialized view or a materialized view log
  • ora-28302 : User does not exist in the LDAP directory service.
  • ora-29833 : indextype does not exist
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-26736 : Data Pump error
  • ora-29829 : implementation type does not exist
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-14070 : option may be specified only for partitioned indices or with REBUILD
  • ora-02733 : osnsnf: database string too long
  • ora-32117 : Source LOB is null
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-19561 : %s requires a DISK channel
  • ora-24066 : invalid privilege specified
  • ora-08271 : sksabln: Buffer size not large enough for archive control string
  • ora-28591 : agent control utility: unable to access parameter file
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-31401 : change source string is not an existing change source
  • ora-07221 : slspool: exec error, unable to start spooler program.
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-08232 : smsdes: cannot detach from SGA
  • 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.