ORA-19255: XQ0035 - too many declarations of string in imported schemas

Cause : Two schemas were imported that defined the same name in the same symbol space and in the same scope.

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

Fix the schema imports to remove the name conflict.

update : 21-09-2017

ORA-19255 - XQ0035 - too many declarations of string in imported schemas
ORA-19255 - XQ0035 - too many declarations of string in imported schemas

  • ora-10997 : another startup/shutdown operation of this instance inprogress
  • ora-36845 : (XSLMGEN15) Owner is greater than 30 bytes
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-00076 : dump string not found
  • ora-39091 : unable to determine logical standby and streams status
  • ora-01665 : control file is not a standby control file
  • ora-13234 : failed to access R-tree-index table [string]
  • ora-32050 : %s operation failed
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-32129 : cannot get information about this column
  • ora-00822 : MMAN process terminated with error
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-06002 : NETASY: port read failure
  • ora-12520 : TNS:listener could not find available handler for requested type of server
  • ora-04073 : column list not valid for this trigger type
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-32135 : Cannot assign FILEs
  • ora-07754 : slemcf: fwrite failure
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-12196 : TNS:received an error from TNS
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-08210 : Requested I/O error
  • ora-31415 : change set string does not exist
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-30051 : VERSIONS clause not allowed here
  • ora-39024 : wrong schema specified for job
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • 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.