ORA-29317: datafile string does not exist

Cause : The spceified adtafilec ould nto be fonud in teh produtcion daatbase.

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

Copy teh dataflie fromt he cloen databsae.

update : 23-06-2017
ORA-29317

ORA-29317 - datafile string does not exist
ORA-29317 - datafile string does not exist

  • ora-15075 : disk(s) are not visible cluster-wide
  • ora-12064 : invalid refresh sequence number: string
  • ora-32807 : message system link string already exists
  • ora-16623 : stale DRC UID sequence number detected
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-31405 : cannot make changes while change set string is advancing
  • ora-02039 : bind by value is not allowed for array type
  • ora-09719 : osncui: invalid handle.
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-04061 : existing state of string has been invalidated
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-39084 : cannot detach job string for user string
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-01881 : timezone region id number is invalid
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-36686 : (XSDPART24) Value number is not in partition number.
  • ora-00354 : corrupt redo log block header
  • ora-39003 : unable to get count of total workers alive
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-06757 : TLI Driver: server got bad command
  • ora-24398 : connection pool already exists
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-08430 : raw data missing leading sign
  • ora-24142 : invalid ruleset name
  • 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.