ORA-13511: invalid INTERVAL string, must be in the range (string, string)

Cause : The user has specified a INTERVAL setting that is not in the supported range of (MIN, MAX).

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

Choose a valid INTERVAL setting and retry the operation.

update : 23-04-2017
ORA-13511

ORA-13511 - invalid INTERVAL string, must be in the range (string, string)
ORA-13511 - invalid INTERVAL string, must be in the range (string, string)

  • ora-19572 : cannot process file string, file is being being resized
  • ora-01779 : cannot modify a column which maps to a non key-preserved table
  • ora-16661 : the standby database needs to be reinstated
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-24342 : unable to destroy a mutex
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-26060 : Can not convert type identifier for column string
  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-14401 : inserted partition key is outside specified partition
  • ora-02475 : maximum cluster chain block count of string has been exceeded
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-24190 : length of payload exceeds string
  • ora-24056 : internal inconsistency for QUEUE string and destination string
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-09933 : Deletion of old password file failed.
  • ora-09743 : smscre: could not attach shared memory.
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-16772 : error switching over between primary and standby databases
  • ora-08003 : sequence string.NEXTVAL exceeds internal limits
  • ora-01614 : instance string (thread string) is busy - cannot enable
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-06518 : PL/SQL: Probe version string incompatible with version string
  • ora-26681 : command type not supported
  • ora-06402 : NETCMN: error receiving break message
  • ora-16231 : DDL barrier
  • 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.