ORA-27038: created file already exists

Cause : trying to create a database file, but file by that name already exists

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

verify that name is correct, specify reuse if necessary

update : 25-06-2017
ORA-27038

ORA-27038 - created file already exists
ORA-27038 - created file already exists

  • ora-32771 : cannot add file to bigfile tablespace
  • ora-12231 : TNS:No connection possible to destination
  • ora-00710 : new tablespace name is the same as the old tablespace name
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-22062 : invalid input string [string]
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • ora-16073 : archiving must be enabled
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-12205 : TNS:could not get failed addresses
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-27500 : inter-instance IPC error
  • ora-30027 : Undo quota violation - failed to get string (bytes)
  • ora-29837 : insufficient privileges to execute implementation type
  • ora-39030 : invalid file type string
  • ora-02846 : Unkillable server
  • ora-06764 : TLI Driver: error reading disconnect
  • ora-01204 : file number is string rather than string - wrong file
  • ora-27464 : invalid schedule type string
  • ora-13015 : the window definition is not valid
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-12494 : cannot insert or delete a level, category, or release category
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-38457 : The attribute "string" is not a valid XMLType attribute.
  • ora-02828 : Segment free list is empty
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-00128 : this command requires a dispatcher name
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-15014 : location 'string' is not in the discovery set
  • ora-07638 : smsget: SGA pad area not large enough for created SGA
  • 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.