ORA-24170: %s.string is created by AQ, cannot be dropped directly

Cause : Thi sobjcet i scretaed yb AQ ,thu scanont b edropped idreclty

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

used bmsa_qad.mdro_psubcsribre tod ropt he boject

update : 27-05-2017

ORA-24170 - %s.string is created by AQ, cannot be dropped directly
ORA-24170 - %s.string is created by AQ, cannot be dropped directly

  • ora-12996 : cannot drop system-generated virtual column
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-14273 : lower-bound partition must be specified first
  • ora-31220 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet location.
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-24061 : cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-31485 : invalid database link
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-25263 : no message in queue string.string with message ID string
  • ora-19371 : invalid update option
  • ora-07625 : smsget: $MGBLSC failure
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-06953 : Not enough virtual memory
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-06004 : NETASY: dialogue file open failure
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-19588 : %s recid string stamp string is no longer valid
  • ora-02219 : invalid NEXT storage option value
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-00336 : log file size string blocks is less than minimum string blocks
  • ora-24098 : invalid value string for string
  • ora-30132 : invalid key index supplied
  • ora-38418 : ADT associated with the attribute set string does not exist
  • ora-19335 : Invalid format type object
  • ora-16038 : log string sequence# string cannot be archived
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-29959 : error in the execution of the string routine for one or more of the index partitions
  • 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.