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 : 28-04-2017
ORA-27038

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

  • ora-39146 : schema "string" does not exist
  • ora-16753 : resource guard could not open standby database
  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-06953 : Not enough virtual memory
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-09368 : Windows 3.1 Two-Task driver unable to spawn ORACLE
  • ora-16505 : site ID is invalid
  • ora-16622 : two or more broker database objects resolve to one physical database
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-01328 : only one build operation may occur at one time
  • ora-25284 : Invalid value string for string
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-01424 : missing or illegal character following the escape character
  • ora-08189 : cannot flashback the table because row movement is not enabled
  • ora-07801 : slbtpd: invalid exponent
  • ora-19900 : RESETLOGS must be specified after recovery to new incarnation
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-28233 : double encryption not supported
  • ora-00092 : LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
  • ora-13416 : invalid geometry parameter
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-07850 : sllfop: bad option
  • ora-14450 : attempt to access a transactional temp table already in use
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-01559 : MAXEXTENTS for rollback segment must be greater than 1
  • ora-38737 : Expected sequence number string doesn't match 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.