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 : 29-06-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-40104 : invalid training data for model build
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-08002 : sequence string.CURRVAL is not yet defined in this session
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-38759 : Database must be mounted by only one instance and not open.
  • ora-19378 : invalid mode
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-07477 : scgcmn: lock manager not initialized.
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-01315 : Log file has been added or removed during select
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-14157 : invalid subpartition name
  • ora-30550 : index depends on a package/function spec/body which is not valid
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-16745 : unable to add DB_UNIQUE_NAME string into the DG_CONFIG list because it is full
  • ora-14070 : option may be specified only for partitioned indices or with REBUILD
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-02149 : Specified partition does not exist
  • ora-01539 : tablespace 'string' is not online
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • 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.