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 : 24-05-2017
ORA-19118

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

  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-29340 : export file appears to be corrupted: [string] [string] [string]
  • ora-22856 : cannot add columns to object tables
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-12453 : label string already exists
  • ora-13906 : The tablepace is not of the right type.
  • ora-10270 : Debug shared cursors
  • ora-01324 : cannot add file string due to DB_ID mismatch
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-28021 : cannot grant global roles
  • ora-02206 : duplicate INITRANS option specification
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-08176 : consistent read failure; rollback data not available
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-21779 : duration not active
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-24398 : connection pool already exists
  • ora-25457 : evaluation function string returns failure
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-31535 : cannot support change source string in this configuration
  • ora-39047 : Jobs of type string cannot use multiple execution streams.
  • ora-36966 : (XSRELTBL10) workspace object must be a dimension.
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-00104 : deadlock detected; all public servers blocked waiting for resources
  • ora-30156 : Out of disk space
  • ora-09743 : smscre: could not attach shared memory.
  • 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.