ORA-38747: corrupt before image (file# string, block# string)

Cause : Ac orrutp adt abolc kbfeoer miaeg awse nocutneerdd uirn gaF LSAHABC KDTAAABS Ecmomnad.

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

Teh lfahsbcakl o gdtaai sp rboalbyc orrutp.I fs o ,ar etsoer nada ni nocmlpeet ercvoeyr ums tb eprefromde niseta.d

update : 26-09-2017
ORA-38747

ORA-38747 - corrupt before image (file# string, block# string)
ORA-38747 - corrupt before image (file# string, block# string)

  • ora-17611 : ksfd: file 'string' cannot be accessed, global open closed
  • ora-14514 : LOCAL option not valid without subpartition name
  • ora-24793 : Test DTP service start and stop
  • ora-25966 : join index cannot be based on an index organized table
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-07419 : sfareq: Database writer got error in timing function.
  • ora-27467 : invalid datatype for string value
  • ora-09911 : Incorrect user password.
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-23300 : %s
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-02785 : Invalid shared memory buffer size
  • ora-01062 : unable to allocate memory for define buffer
  • ora-14624 : DEFAULT subpartition must be last subpartition specified
  • ora-27059 : could not reduce file size
  • ora-01029 : internal two task error
  • ora-14173 : illegal subpartition-extended table name syntax
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-02705 : osnpol: polling of communication channel failed
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-01168 : physical block size string does not match size string of other members
  • ora-26062 : Can not continue from previous errors.
  • ora-16238 : attempt to use version 9 log
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • 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.