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 : 28-04-2017

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

  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-02465 : Inappropriate use of the HASH IS option
  • ora-32338 : on commit refresh grab all the detailed tables
  • ora-13192 : failed to read number of element rows
  • ora-01496 : specified chain row table form incorrect
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-28584 : heterogeneous apply internal error
  • ora-08429 : raw data has invalid digit in display type data
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-19274 : XQ0054 - variable initialization failed due to circularity
  • ora-04051 : user string cannot use database link string.string
  • ora-00400 : invalid release value string for parameter string
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-23491 : no valid extension request at "string"
  • ora-10661 : Invalid option specified
  • ora-30649 : missing DIRECTORY keyword
  • ora-31476 : a change table data column is missing from the source table
  • ora-31630 : a job name is required to attach a job for user string
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-09920 : Unable to get sensitivity label from connection
  • ora-29525 : referenced name is too long: 'string'
  • ora-09981 : skxfqdreg: Error Adding a page to the SDI buffer pool
  • ora-40208 : duplicate or multiple algorithm settings for function string
  • ora-00071 : process number must be between 1 and string
  • ora-01721 : USERENV(COMMITSCN) invoked more than once in a transaction
  • ora-00450 : background process 'string' did not start
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-12026 : invalid filter column detected
  • 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.