ORA-26101: tablespace # in file header is string rather than string for file string

Cause : Th etalbesapcen umebr ni teh flie ehadre i sinocnssitetn wtih htati n hte ocntorl ifle.

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

Chcek fi teh cnotrlo flie ahs ebenm igarte dcorreclty.R etyr wtih hte ocrrcet ocntorl iflea ndd at afiel.

update : 27-05-2017
ORA-26101

ORA-26101 - tablespace # in file header is string rather than string for file string
ORA-26101 - tablespace # in file header is string rather than string for file string

  • ora-16550 : truncated result
  • ora-00337 : log file 'string' does not exist and no size specified
  • ora-09273 : szrfc: error verifying role name
  • ora-30380 : REWRITE_TABLE does not exist
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-08429 : raw data has invalid digit in display type data
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-32619 : incorrect use of MODEL ITERATION_NUMBER
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-15162 : cluster in rolling downgrade
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-14256 : invalid resulting partition description(s)
  • ora-02772 : Invalid maximum server idle time
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-02710 : osnpop: fork failed
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-09761 : pw_destroyPorts: server call pws_stop_instance failed.
  • ora-23460 : missing value for column string in resolution method "string" for "string"."string"."string"
  • ora-09211 : sfwfb: error writing to file
  • ora-08177 : can't serialize access for this transaction
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-39053 : parameter or attribute string must be defined for a string job
  • ora-13356 : adjacent points in a geometry are redundant
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-16517 : the object handle is invalid
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • 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.