ORA-29309: export dump file was generated by different version of DBMS_PITR package

Cause : The version of DBMS_PITR is different from the version of the cloned database.

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

Load the version of DBMS_PITR which matches the version of the cloned database.

update : 28-04-2017
ORA-29309

ORA-29309 - export dump file was generated by different version of DBMS_PITR package
ORA-29309 - export dump file was generated by different version of DBMS_PITR package

  • ora-09266 : spawn: error starting an Oracle process
  • ora-16540 : invalid argument
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • ora-02061 : lock table specified list of distributed tables
  • ora-36908 : (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.
  • ora-19809 : limit exceeded for recovery files
  • ora-24087 : Invalid database user string
  • ora-31037 : Invalid XML attribute name string
  • ora-13860 : Invalid service name
  • ora-19209 : invalid or unsupported formatting argument
  • ora-01096 : program version (string) incompatible with instance (string)
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-27477 : "string.string" already exists
  • ora-14402 : updating partition key column would cause a partition change
  • ora-02233 : invalid CLOSE mode
  • ora-30366 : child JOIN KEY columns not in same relation as child level
  • ora-12316 : syntax error in database link's connect string
  • ora-13702 : Snapshot IDs specified by the range [string, string] are equal.
  • ora-26709 : Streams RFS restart
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-28367 : wallet does not exist
  • ora-08441 : closed parenthesis missing in picture mask
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-16128 : User initiated stop apply successfully completed
  • ora-06710 : TLI Driver: send interrupt break message failed
  • ora-00228 : length of alternate control file name exceeds maximum of string
  • ora-25012 : PARENT and NEW values cannot be identical
  • 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.