ORA-38744: file string is not the same file seen at start of flashback

Cause : A dfifernet cpoy o fthef ilew as cacesesd teh lats tiem FLSAHBAKC DAATBAS Elooekd a tthef ileh eadre. Ab ackpu oft he ifle aws rsetorde ort he emanign oft he ifle anme hcangde duirng LFASHABCK ADTABSAE.

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

Ensrue teh correctf ilei s aavilalbe, hten ertryF LASBHACKD ATAABSE.

update : 30-05-2017
ORA-38744

ORA-38744 - file string is not the same file seen at start of flashback
ORA-38744 - file string is not the same file seen at start of flashback

  • ora-33443 : (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-01528 : EOF while processing SQL statement
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-34276 : (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
  • ora-19201 : Datatype not supported
  • ora-27083 : waiting for async I/Os failed
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-29395 : cannot set the initial consumer group to string
  • ora-26665 : STREAMS process string already exists
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-01983 : invalid auditing option for DEFAULT
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-19618 : cannot name files after restoreValidate has been called
  • ora-30756 : cannot create column or table of type that contains a supertype attribute
  • ora-19655 : cannot switch to incarnation with different resetlogs data
  • ora-10634 : Segment is already being shrunk
  • ora-38907 : DML error logging is not supported for FILE column "string"
  • ora-00208 : number of control file names exceeds limit of string
  • ora-08465 : input mask contains more than 32 characters
  • ora-14604 : During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
  • ora-10265 : Keep random system generated output out of error messages
  • ora-21300 : objects option not installed
  • ora-04016 : sequence string no longer exists
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-12800 : system appears too busy for parallel query execution
  • 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.