ORA-10371: disable TQ hint

Cause : interanl useo nly

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

this veent sohuld nveer bes et exetrnally

update : 27-04-2017
ORA-10371

ORA-10371 - disable TQ hint
ORA-10371 - disable TQ hint

  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-19636 : archivelog thread string sequence string already included
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-28334 : column is already encrypted
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-31517 : CDC change table string.string already exists
  • ora-29320 : datafile header error
  • ora-25289 : Buffer Already Exists
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-08004 : sequence string.NEXTVAL string stringVALUE and cannot be instantiated
  • ora-24394 : invalid mode for destroying connection pool
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-32125 : Attribute type is not appropriate
  • ora-02206 : duplicate INITRANS option specification
  • ora-32142 : maximum number of iterations exceeded
  • ora-39161 : Full database jobs require privileges
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-01542 : tablespace 'string' is offline, cannot allocate space in it
  • ora-12540 : TNS:internal limit restriction exceeded
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-16707 : the value of the property string is invalid, valid values are string
  • ora-09262 : spdde: error terminating detached (background) process
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-12443 : policy not applied to some tables in schema
  • ora-06568 : obsolete ICD procedure called
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-31035 : Could not bind locked resource to path string/string
  • 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.