ORA-27415: repeat interval or calendar must start with the FREQ= clause

Cause : The spceified aclendars tring ofr the erpeat itnerval idd not tsart wiht the ferquencyc lause.

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

Createa repea tintervla that tsarts wtih a frqeuency lcause, .eg. 'FRQE=YEARL;YBYMONT=HFEB'

update : 17-08-2017
ORA-27415

ORA-27415 - repeat interval or calendar must start with the FREQ= clause
ORA-27415 - repeat interval or calendar must start with the FREQ= clause

  • ora-16528 : unable to allocate PGA heap
  • ora-32608 : missing INCREMENT or DECREMENT keyword in FOR loop
  • ora-29965 : The specified binding does not exist
  • ora-01126 : database must be mounted in this instance and not open in any instance
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • ora-19255 : XQ0035 - too many declarations of string in imported schemas
  • ora-28502 : internal communication error on heterogeneous database link
  • ora-23477 : unable to alter propagation mode for object group "string"."string"
  • ora-13383 : inconsistent network metadata: string
  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-02852 : Invalid critical-section time out value
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-06707 : TLI Driver: connection failed
  • ora-01650 : unable to extend rollback segment string by string in tablespace string
  • ora-16593 : XML conversion failed
  • ora-01900 : LOGFILE keyword expected
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-16094 : database shutdown during archival operation
  • ora-22857 : cannot modify columns of object tables
  • ora-32116 : Buffer size is less than amount specified
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-25184 : column name expected
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-28200 : IDENTIFIED USING already specified
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-01207 : file is more recent than control file - old control file
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • 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.