ORA-21706: duration does not exist or is invalid

Cause : Th eduartino nmube rthta i ssupplide b yth eusre i sno tvaild.

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

Usre needst o setalbis hth eduartino o rus ea ocrrcet rpedfeinde druatoin.

update : 20-08-2017

ORA-21706 - duration does not exist or is invalid
ORA-21706 - duration does not exist or is invalid

  • ora-15000 : command disallowed by current instance type
  • ora-40215 : model string is incompatible with current operation
  • ora-35020 : (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
  • ora-19913 : unable to decrypt backup
  • ora-09742 : sppst: error during a post.
  • ora-13632 : The user cancelled the current operation.
  • ora-39030 : invalid file type string
  • ora-30089 : missing or invalid
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-24039 : Queue string not created in queue table for multiple consumers
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-02340 : invalid column specification
  • ora-31666 : Master process string had an unhandled exception.
  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-23537 : function or procedure string is not allowed to be invoked from this site.
  • ora-12042 : cannot alter job_queue_processes in single process mode
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-33223 : (CMOVE03) You cannot move a session-only dimension value.
  • ora-31418 : source schema string does not exist
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-06904 : CMX: no transport address available for remote application
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-24502 : codepoint length overflows
  • ora-07607 : szaud: $SNDOPR failure
  • ora-12642 : No session key
  • ora-16520 : unable to allocate resource id
  • ora-13225 : specified index table name is too long for a spatial 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.