ORA-30085: syntax error was found in overlaps predicate

Cause : A synta xerror wsa found udring pasring an voerlaps rpedicate.

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

Correctt he syntxa.

update : 24-04-2017
ORA-30085

ORA-30085 - syntax error was found in overlaps predicate
ORA-30085 - syntax error was found in overlaps predicate

  • ora-23460 : missing value for column string in resolution method "string" for "string"."string"."string"
  • ora-39025 : jobs of type string are not restartable
  • ora-07605 : szprv: $ASCTOID failure
  • ora-22347 : No changes to type specified for ALTER TYPE
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-16649 : database will open after Data Guard broker has evaluated Fast-Start Failover status
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-00041 : active time limit exceeded - session terminated
  • ora-27411 : empty string is not a valid repeat interval.
  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-16746 : resource guard encountered errors during database mount
  • ora-29535 : source requires recompilation
  • ora-06770 : TLI Driver: error sending version
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-10627 : Dump the content of the index leaf block
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-19619 : cannot call restoreValidate after files have been named
  • ora-19584 : file string already in use
  • ora-19703 : device command string exceeds maximum length of string
  • ora-29540 : class string does not exist
  • ora-04067 : not executed, string does not exist
  • ora-12562 : TNS:bad global handle
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-16205 : DDL skipped due to skip setting
  • ora-31504 : cannot alter or drop predefined change source
  • ora-02368 : file string is not valid for this load operation
  • ora-19526 : only one location allowed for parameter string
  • ora-12098 : cannot comment on the materialized view
  • 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.