ORA-23420: interval must evaluate to a time in the future

Cause : The parameter "interval" evaluates to a time earlier than SYSDATE.

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

Choose an expression that evaluates to a time later than SYSDATE.

update : 25-04-2017
ORA-23420

ORA-23420 - interval must evaluate to a time in the future
ORA-23420 - interval must evaluate to a time in the future

  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-13421 : null or invalid cell value
  • ora-32028 : Syslog facility or level not recognized
  • ora-32005 : error while parsing size specification [string]
  • ora-36405 : (XSSPROP05) Property ignored for object workspace object:
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-38752 : file string does not exist
  • ora-31491 : could not add logfile to LogMiner session
  • ora-00965 : column aliases not allowed for '*'
  • ora-39053 : parameter or attribute string must be defined for a string job
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-10261 : Limit the size of the PGA heap
  • ora-29876 : failed in the execution of the ODCIINDEXDELETE routine
  • ora-00203 : using the wrong control files
  • ora-30000 : missing either trim specification or char expression in TRIM
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-01284 : file string cannot be opened
  • ora-12681 : Login failed: the SecurID card does not have a pincode yet
  • ora-13156 : table to be registered string.string is not empty
  • ora-13414 : invalid pyramid parameter
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-01542 : tablespace 'string' is offline, cannot allocate space in it
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-25110 : NOSORT may not be used with a bitmap index
  • 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.