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 : 23-09-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-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-02159 : installed DLM does not support releasable locking mode
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-01576 : The instance string is not enabled
  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-19235 : XQ0015 - unsupported must-understand extension
  • ora-33458 : (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
  • ora-12405 : invalid label list
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-12042 : cannot alter job_queue_processes in single process mode
  • ora-27074 : unable to determine limit for open files
  • ora-13518 : Invalid database id (string)
  • ora-01049 : Bind by name is not spupportted in streamed RPC
  • ora-09773 : osnmgetdatmsg: message from host had incorrect message type
  • ora-34001 : (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
  • ora-31074 : XML comment length string exceeds maximum string
  • ora-03207 : subpartitioned type must be specified for composite object
  • ora-19627 : cannot read backup pieces during control file application
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-08115 : can not online create/rebuild this index type
  • ora-06779 : TLI Driver: error reading ccode
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-25115 : duplicate BLOCK option specification
  • ora-10582 : The control file is not a backup control file
  • ora-24794 : no active DTP service found
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • 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.