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 : 18-08-2017
ORA-19208

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

  • ora-02428 : could not add foreign key reference
  • ora-30449 : syntax error in parameter string
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-28334 : column is already encrypted
  • ora-27145 : insufficient resources for requested number of processes
  • ora-12912 : Dictionary managed tablespace specified as temporary tablespace
  • ora-01469 : PRIOR can only be followed by a column name
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-04933 : initial service identifier is non-zero
  • ora-16402 : ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
  • ora-10636 : ROW MOVEMENT is not enabled
  • ora-01696 : control file is not a clone control file
  • ora-31615 : routine string received this error: string
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-01096 : program version (string) incompatible with instance (string)
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-14298 : LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-12457 : security label exceeded maximum allowable length
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-40282 : invalid cost matrix
  • ora-20000 : %s
  • ora-26667 : invalid STREAMS parameter string
  • ora-03248 : Too much of segment creation activity during migration
  • ora-01601 : illegal bucket size in clause "string" of 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.