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 : 24-05-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-28663 : Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
  • ora-19025 : EXTRACTVALUE returns value of only one node
  • ora-13869 : Instance-wide SQL tracing on instance string is already enabled
  • ora-12407 : unauthorized operation for policy string
  • ora-38957 : Target database not 10.0.0.0 compatible
  • ora-19618 : cannot name files after restoreValidate has been called
  • ora-25467 : table alias not specified
  • ora-04041 : package specification must be created first before creating package body
  • ora-31638 : cannot attach to job string for user string
  • ora-10916 : TABLESPACE GROUP already specified
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-01515 : error dropping log group string: no such log
  • ora-12445 : cannot change HIDDEN property of column
  • ora-40253 : no target counter examples were found
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-19810 : Cannot create temporary control file string in DB_RECOVERY_FILE_DEST
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-39958 : invalid warning category qualifier
  • ora-01771 : illegal option for a clustered table
  • ora-00323 : Current log of thread string not useable and all others need archiving
  • ora-00134 : invalid DISPATCHERS specification #string
  • ora-23325 : parameter type is not string
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • ora-07631 : smcacx: $EXPREG failure
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-37181 : expected exactly string columns for dimension string, got string
  • ora-16033 : parameter string destination cannot be the same as parameter string destination
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-30175 : invalid type given for an argument
  • 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.