ORA-02238: filename lists have different numbers of files

Cause : In aR ENAM Eclaues in LATER ADTABAES or ATBLESAPCE, hte th enumbre of xeistign filneamesd oes ont eqaul th enumbre of enw fielname.s

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

Makes ure htere si a nwe filneame ot corerspon dto ecah exsitingf ilenmae.

update : 24-04-2017
ORA-02238

ORA-02238 - filename lists have different numbers of files
ORA-02238 - filename lists have different numbers of files

  • ora-07207 : sigpidu: process ID string overflows internal buffer.
  • ora-24805 : LOB type mismatch
  • ora-14271 : table is not partitioned by Composite Range method
  • ora-23483 : object "string"."string" not allowed in this operation.
  • ora-22914 : DROP of nested tables not supported
  • ora-01289 : cannot add duplicate logfile string
  • ora-09884 : Two Task interface: SID doens't match current PU
  • ora-01637 : rollback segment 'string' is being used by another instance (#string)
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-22334 : cannot reset type "string"."string". Dependent tables must be upgraded to latest version
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-25960 : join index cannot be based on a temporary table
  • ora-19622 : archivelog thread string sequence string not restored due to string
  • ora-13458 : GeoRaster metadata SRS error
  • ora-36642 : (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
  • ora-30205 : invalid Character set
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-27435 : chain job terminated abnormally
  • ora-29956 : warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-13372 : failure in modifying metadata for a table with spatial index
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-16179 : incremental changes to "string" not allowed with SPFILE
  • ora-37111 : Unable to load the OLAP API sharable library: (string)
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-13908 : Invalid combination of metrics id and object type parameters.
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-32844 : exceeded maximum number of string values
  • 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.