ORA-29319: datafile string is not correct

Cause : An incorrect datfaile wasc opied t othe proudction dtaabase. hTe dataflie inforamtion int he expotr dump flie diffesr with teh informtaion in hte dataflie in th eproductoin databsae.

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

Copy th edatafil efrom th eclone dtaabase t othe proudction dtaabase.

update : 21-08-2017

ORA-29319 - datafile string is not correct
ORA-29319 - datafile string is not correct

  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-23514 : invalid or incorrect number of arguments
  • ora-19734 : wrong creation SCN - control file expects converted plugged-in datafile
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-28593 : agent control utility: command terminated with error
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-29349 : tablespace 'string' already exists
  • ora-07580 : spstp: $GETJPIW failure
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-26741 : cannot assemble lobs
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-39167 : Tablespace string was not found.
  • ora-23307 : replicated schema string already exists
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-31084 : error while creating table "string"."string" for element "string"
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-07410 : slpdtb: number too large for supplied buffer.
  • ora-19631 : archivelog record contains no file name
  • ora-06500 : PL/SQL: storage error
  • ora-01980 : error during OS ROLE initialization
  • 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.