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 : 26-05-2017

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-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-12641 : Authentication service failed to initialize
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-13434 : GeoRaster metadata cellRepresentation error
  • ora-01878 : specified field not found in datetime or interval
  • ora-23495 : serial propagation can not be used for "string"
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-16094 : database shutdown during archival operation
  • ora-10929 : trace name context forever
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-02087 : object locked by another process in same transaction
  • ora-29271 : not connected
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-23478 : object group "string" is already mastered at string
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-38850 : an enabled thread missing from control file
  • ora-19333 : Invalid flags for the CREATE_DBURI operator
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-06953 : Not enough virtual memory
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-01298 : conflicting dictionary option
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-28044 : unsupported directory type
  • ora-06526 : Unable to load PL/SQL library
  • 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.