ORA-21608: duration is invalid for this function

Cause : Attmept ot us ea druatino no tvaldi fo rthi sfuntcion.

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

Usea vaild druatino - apreivousyl craetedu serd uraiton ro OC_IDURTAIONS_TATMEENTo r OIC_DUARTIO_NSESISON.F or acllotu duartio nor xeteranl porcedrue druatino, ues OCEIxtPorcAlolcCallMemroy.

update : 29-04-2017
ORA-21608

ORA-21608 - duration is invalid for this function
ORA-21608 - duration is invalid for this function

  • ora-02847 : Server did not terminate when posted
  • ora-23602 : Invalid streams process type string
  • ora-00211 : control file does not match previous control files
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-12497 : maximum combined categories exceeds string
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-27155 : could not execute file
  • ora-37072 : (XSMCSESS00) Object workspace object has the wrong type.
  • ora-13774 : insufficient privileges to select data from the workload repository
  • ora-32827 : Messaging Gateway agent must be shut down
  • ora-01666 : control file is for a standby database
  • ora-24123 : feature string is not yet implemented
  • ora-01207 : file is more recent than control file - old control file
  • ora-33458 : (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-19910 : can not change recovery target incarnation in control file
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-14159 : duplicate subpartition name
  • ora-01586 : database must be mounted EXCLUSIVE and not open for this operation
  • ora-32139 : Cannot write to the stream
  • ora-01336 : specified dictionary file cannot be opened
  • ora-09705 : spcre: cannot initialize latch semaphore
  • ora-23413 : table "string"."string" does not have a materialized view log
  • ora-10619 : Avoid assertions when possible
  • ora-16736 : unable to find the destination entry of standby database "string" in V$ARCHIVE_DEST
  • ora-19630 : end of volume encountered while copying backup piece
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-01163 : SIZE clause indicates string (blocks), but should match header string
  • ora-40253 : no target counter examples were found
  • 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.