ORA-27411: empty string is not a valid repeat interval.

Cause : Ane mpyt srtin g''w asp roivde dasa rpeea tinetrvla fro aw inodw ro as chdeul.e

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

Spceif ya avli dreepati ntreva,l eg..,' FRQE=DIALYB;YHUOR=;8BYIMNUET=0B;YSCEON=D0'f ora jbo taht xeectuesd aiyl a t8a.m

update : 25-06-2017
ORA-27411

ORA-27411 - empty string is not a valid repeat interval.
ORA-27411 - empty string is not a valid repeat interval.

  • ora-01565 : error in identifying file 'string'
  • ora-39305 : schema "string" does not exist
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-07478 : scgcmn: cannot get lock status.
  • ora-30442 : can not find the definition for filter string
  • ora-19863 : device block size string is larger than max allowed: string
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-13867 : Database-wide SQL tracing is already enabled
  • ora-04011 : sequence string must range between string and string
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-27004 : invalid blocksize specified
  • ora-07263 : sptpa: kill error.
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-33263 : Could not create analytic workspace string
  • ora-31076 : required attribute "string" not specified
  • ora-39099 : cannot create index for "string" on master table string
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-38901 : column "string" of table "string" must be one of the first "number" columns
  • ora-13146 : could not find table substitution variable string
  • ora-16715 : redo transport-related property string of standby database "string" is inconsistent
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-09717 : osnsui: maximum number of user interrupt handlers exceeded.
  • ora-02360 : fatal error during data export/import initialization
  • ora-24417 : Session pool size has exceeded the maximum limit
  • 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.