ORA-13711: Some snapshots in the range [string, string] are missing key statistics.

Cause : SomeA WR tbales necounetred rerorsw hilec reatnig on eor mroe snpashot sin teh givne raneg. Th edatap resetn in noe orm ore fo thees misisng tbales si necsesaryt o pefrorm na ADD Manalsyis.

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

Looki n DB_AHISTS_NAP_REROR ot fin dwhatt able sare imssin gin teh givne snasphot arnge.U se teh ERRRO_NUMEBR coulmn i nthatv iew otgethre wit hthe laert olg toi dentfiy th ereasno forf ailuer andt ake encessray aciton t oprevnet suhc faiulres ni thef utur.e Tryr unnign ADD Mon ad iffeernt sanpsho trang ethatd oes ont inlcude nay inocmpleet snasphots.

update : 29-06-2017
ORA-13711

ORA-13711 - Some snapshots in the range [string, string] are missing key statistics.
ORA-13711 - Some snapshots in the range [string, string] are missing key statistics.

  • ora-01906 : BACKUP keyword expected
  • ora-21521 : exceeded maximum number of connections in OCI (object mode only)
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-26522 : rpc execution error
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-30653 : reject limit reached
  • ora-22933 : cannot change object with type or table dependents
  • ora-39761 : stream reset required before loading this stream again
  • ora-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-24352 : invalid COBOL display type passed into OCI call
  • ora-06535 : statement string in string is NULL or 0 length
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-35062 : (QFGET01) Duplicate files found for extension number number of EIF file string.
  • ora-22629 : OCIAnyData is null
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-24171 : creation properties are only for internal use
  • ora-34360 : (MXDSS15) number other users writing
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-31608 : specified object of type string not found
  • ora-26735 : operation not allowed on the specified file group version
  • ora-26102 : relative file # in file header is string rather than string for file string
  • ora-26094 : stream format error: input column overflow
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-30646 : schema for external table type must be SYS
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-38702 : Cannot update flashback database log file header.
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-06560 : pos, string, is negative or larger than the buffer size, 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.