ORA-19721: Cannot find datafile with absolute file number string in tablespace string

Cause : Can not find one of the datafile that should be in the Pluggable Set.

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

Make sure all datafiles are specified via import command line option or parameter files.

update : 27-05-2017

ORA-19721 - Cannot find datafile with absolute file number string in tablespace string
ORA-19721 - Cannot find datafile with absolute file number string in tablespace string

  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-25471 : attribute name not specified for variable: string
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-39167 : Tablespace string was not found.
  • ora-08119 : The new initrans will make the index too big
  • ora-16514 : the request was not found
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-13632 : The user cancelled the current operation.
  • ora-16554 : translation not valid
  • ora-12732 : invalid interval value in regular expression
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-12321 : database (link name string) is not open and AUTO_MOUNTING=FALSE
  • ora-27146 : post/wait initialization failed
  • ora-19808 : recovery destination parameter mismatch
  • ora-26032 : index string.string loading aborted after string keys
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-15031 : disk specification 'string' matches no disks
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-30732 : table contains no user-visible columns
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-30464 : no summaries exist
  • ora-28601 : invalid [no]MINIMIZE option
  • 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.