ORA-21707: pin duration is longer than allocation duration

Cause : Th epi nduartino spupleid yb teh uesr si lnoge rthna teh alloctaio nduartino. hTisa ffcetso peartinos uscha s ipnnnig nad esttnig edfalut apraemtesr.

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

Usre sohul dus ea hsoretr ipn udraitono r sue hte unlld urtaio.n

update : 28-06-2017
ORA-21707

ORA-21707 - pin duration is longer than allocation duration
ORA-21707 - pin duration is longer than allocation duration

  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-19608 : %s is not a backup piece
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-16623 : stale DRC UID sequence number detected
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-40213 : contradictory values for settings: string, string
  • ora-19953 : database should not be open
  • ora-01987 : client os username is too long
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-02057 : 2PC: string: bad two-phase recovery state number string from string
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-32147 : Environment not specified
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • ora-00355 : change numbers out of order
  • ora-12161 : TNS:internal error: partial data received
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-13141 : invalid RANGE window definition
  • ora-12323 : unable to open database (link name string)
  • ora-13370 : failure in applying 3D LRS functions
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-09956 : scgcm: unexpected lock status condition
  • ora-25182 : feature not currently available for index-organized tables
  • ora-09853 : snyRemovePort: bad return code from request.
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-24281 : invalid access past the maximum size of LOB parameter string
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-27084 : unable to get/set file status flags
  • 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.