ORA-19208: parameter string of function string must be aliased

Cause : The indicated parameter of the XML generation function has not been aliased, although it is an expression.

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

Specify an alias for the expression using the AS clause.

update : 25-06-2017

ORA-19208 - parameter string of function string must be aliased
ORA-19208 - parameter string of function string must be aliased

  • ora-00032 : invalid session migration password
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-29286 : internal error
  • ora-13753 : "SQL Tuning Set" "string" already exists for user "string".
  • ora-14098 : index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-02248 : invalid option for ALTER SESSION
  • ora-13607 : The specified task or object string already exists
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-12019 : master table is a synonym to a remote object
  • ora-01182 : cannot create database file string - file is in use or recovery
  • ora-03130 : the buffer for the next piece to be fetched is required
  • ora-01655 : unable to extend cluster string.string by string in tablespace string
  • ora-30430 : list does not contain any valid summaries
  • ora-02772 : Invalid maximum server idle time
  • ora-12629 : TNS:no event test
  • ora-13191 : failed to read SDO_ORDCNT value
  • ora-12409 : policy startup failure for string policy
  • ora-16212 : number processes specified for APPLY is too great
  • ora-15056 : additional error message
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-22340 : cannot string type "string"."string". Dependent tables must be upgraded to latest version
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-06563 : top level procedure/function specified, cannot have subparts
  • ora-38908 : internal error occurred during DML Error Logging
  • ora-12074 : invalid memory address
  • ora-23349 : cannot generate replication support for functions
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-15032 : not all alterations performed
  • 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.