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-09-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-37134 : (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.
  • ora-13866 : Client identifier must be specified
  • ora-30445 : workload queries not found
  • ora-31113 : XDB configuration may not be updated with non-schema compliant data
  • ora-19373 : invalid staging table or tablespace
  • ora-23436 : missing template authorization for user
  • ora-02881 : sou2o: Could not revoke access to protected memory
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-30513 : cannot create system triggers of INSTEAD OF type
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-29251 : Index1 is greater than Index2 in call to dbms_sql.bind_array
  • ora-29550 : Java session state cleared
  • ora-36162 : (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
  • ora-08313 : sllfop: could not allocate buffers
  • ora-07514 : scgcan: $deq unexpected return while canceling lock
  • ora-12609 : TNS: Receive timeout occurred
  • ora-30100 : internal error [number]
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-07824 : sspain: $SETIMR failure
  • ora-06127 : NETTCP: unable to change username
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-07507 : scgcm: unexpected lock status condition
  • ora-12225 : TNS:destination host unreachable
  • 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.