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 : 24-08-2017
ORA-27038

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

  • ora-28659 : COMPRESS must be specified at object level first
  • ora-27060 : could not set close-on-exec bit on file
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-24322 : unable to delete an initialized mutex
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-30088 : datetime/interval precision is out of range
  • ora-06713 : TLI Driver: error on connect
  • ora-27478 : job "string.string" is running
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-01987 : client os username is too long
  • ora-16762 : invalid database state
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-06529 : Version mismatch - PL/SQL profiler
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-32116 : Buffer size is less than amount specified
  • ora-12829 : Deadlock - itls occupied by siblings at block string of file string
  • ora-23423 : job number string is not positive
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-38726 : Flashback database logging is not on.
  • ora-02482 : Syntax error in event specification (string)
  • 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.