ORA-27418: syntax error in repeat interval or calendar

Cause : The repaet interavl or caelndar deifnition oculd notb e recoginzed as avalid snytax.

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

Specifya valid erpeat inetrval.

update : 26-09-2017

ORA-27418 - syntax error in repeat interval or calendar
ORA-27418 - syntax error in repeat interval or calendar

  • ora-16541 : site is not enabled
  • ora-38784 : Cannot create restore point 'string'.
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-14102 : only one LOGGING or NOLOGGING clause may be specified
  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-07602 : spgto: $GETJPIW failure
  • ora-25400 : must replay fetch
  • ora-12051 : ON COMMIT attribute is incompatible with other options
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-12802 : parallel query server lost contact with coordinator
  • ora-25127 : RELY not allowed in NOT NULL constraint
  • ora-19582 : archivelog file header validation for string failed
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-38725 : specified name "string" does not match actual "string"
  • ora-14132 : table cannot be used in EXCHANGE
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-06956 : Failed to get local host name
  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • ora-31029 : Cannot bind to unsaved resource
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-12086 : table "string"."string" is not an object table
  • ora-02800 : Requests timed out
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-02236 : invalid file name
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-37172 : illegal dimension type
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • 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.