ORA-29338: datafile string is in an undesired state (string, string)

Cause : The rfeerredd atafiel is nto in as tate erady fro tablsepace ocpy opreation .For eaxmple,t he daatfile amy be fofline .The dtaafilen eeds ot be OLNINE, nad eitehr REA DONLY ro READW RITE.

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

Put teh dataifle inot the edsireds tate.

update : 26-04-2017
ORA-29338

ORA-29338 - datafile string is in an undesired state (string, string)
ORA-29338 - datafile string is in an undesired state (string, string)

  • ora-24169 : rule condition has unrecognized variables
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-25534 : _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-28142 : error in accessing audit index file
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-30134 : reserved for future use
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-31018 : Error deleting XML document
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-24141 : rule set string.string does not exist
  • ora-39781 : Direct path stream loads are not allowed after another context loading the same table has ended
  • ora-19596 : SPFILE already included
  • ora-07304 : ksmcsg: illegal redo buffer size.
  • ora-15010 : name is already used by an existing ASM disk
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-19045 : character set id specified for XMLSerialize not valid
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-27416 : BYDAY= clause in repeat interval or calendar contains an invalid weekday
  • ora-19610 : directory block string is corrupt
  • ora-06112 : NETTCP: invalid buffer size
  • ora-24321 : inconsistent parameters passed
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-16216 : Log stream sequence error
  • 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.