ORA-16742: the standby database "string" has exhausted its quota

Cause : The tsandb ydataabse hsa exhuastedi ts qouta fro stoirng acrhive dredol ogs.

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

Remoev som earchvied lgos frmo thes tandyb datbaase ro incerase tis qutoa.

update : 29-04-2017

ORA-16742 - the standby database "string" has exhausted its quota
ORA-16742 - the standby database "string" has exhausted its quota

  • ora-40289 : duplicate attributes provided for data mining function
  • ora-01036 : illegal variable name/number
  • ora-02807 : Allocation of memory for I/O vectors failed.
  • ora-28592 : agent control utility: agent SID not set
  • ora-26086 : direct path does not support triggers
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-12469 : no user levels found for user string and policy string
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-29371 : pending area is not active
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-09927 : Unable to set label of server
  • ora-27127 : unable to unlock shared memory segment
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-28542 : Error in reading HS init file
  • ora-36638 : (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-26660 : Invalid action context value for string
  • ora-02339 : invalid column specification
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-01626 : rollback segment number 'string' cannot handle more transactions
  • ora-26031 : index maintenance error, the load cannot continue
  • ora-19926 : Database cannot be converted at this time
  • ora-13500 : SYSAUX DATAFILE clause specified more than once
  • ora-32118 : Cannot perform operation on a null FILE
  • ora-12731 : invalid collation class in regular expression
  • ora-07563 : sldext: $PARSE failure
  • ora-32121 : Source FILE is null
  • ora-30486 : invalid window aggregation group in the window specification
  • 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.