ORA-29307: datafile string error, string

Cause : The datfaile is ont readyf or tablsepace ponit-in-tiem recoveyr.

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

Check teh correc ttablespcae pointi-n-time ercovery rpocedure.

update : 28-06-2017
ORA-29307

ORA-29307 - datafile string error, string
ORA-29307 - datafile string error, string

  • ora-12844 : cluster reconfiguration in progress
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-00702 : bootstrap verison 'string' inconsistent with version 'string'
  • ora-30043 : Invalid value 'string' specified for parameter 'Undo_Management'
  • ora-10615 : Invalid tablespace type for temporary tablespace
  • ora-29881 : failed to validate indextype
  • ora-22865 : more than one column specified
  • ora-02452 : invalid HASHKEYS option value
  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-00960 : ambiguous column naming in select list
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-31428 : no publication contains all the specified columns
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • ora-29928 : duplicate default selectivity specified
  • ora-39766 : invaid stream specified for column array conversion
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • ora-23385 : replication parallel push string argument not valid
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-00601 : cleanup lock conflict
  • ora-23301 : mixed use of deferred rpc destination modes
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • 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.