ORA-19118: duplicate default namespace definition - string

Cause : More than one default namespace declaration used the given namespace URI.

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

Remove the duplicate default namespace definition.

update : 17-08-2017
ORA-19118

ORA-19118 - duplicate default namespace definition - string
ORA-19118 - duplicate default namespace definition - string

  • ora-25137 : Data value out of range
  • ora-27052 : unable to flush file data
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-16701 : generic resource guard request failed
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-16642 : db_unique_name mismatch
  • ora-09957 : Unable to send termination request to IMON
  • ora-36921 : (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-12726 : unmatched bracket in regular expression
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-06419 : NETCMN: server can not start oracle
  • ora-32801 : invalid value string for string
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-06535 : statement string in string is NULL or 0 length
  • ora-32695 : HTI: Not enough memory
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-15047 : ASM file name 'string' is not in multiple-file creation form
  • ora-14622 : Value string already exists in subpartition string
  • ora-24771 : cannot detach, prepare or forget a local transaction
  • ora-23362 : invalid user
  • ora-02045 : too many local sessions participating in global transaction
  • ora-22890 : cannot specify name for REF column constraint
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-06531 : Reference to uninitialized collection
  • 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.