ORA-19205: Attribute 'string' qualifies a non-scalar value in the select list

Cause : The attribute immediately follows a value of object or collection type in the select list or type definition.

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

Remove the '@' sign, or make the previous value a scalar.

update : 27-04-2017
ORA-19205

ORA-19205 - Attribute 'string' qualifies a non-scalar value in the select list
ORA-19205 - Attribute 'string' qualifies a non-scalar value in the select list

  • ora-12082 : "string"."string" cannot be index organized
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-09775 : osnmrs: reset protocol error
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-37153 : unknown exception caught: (case string)
  • ora-12490 : DBHIGH cannot be lowered
  • ora-24762 : server failed due to unspecified error
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-01070 : Using an old version of Oracle for the server
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-01543 : tablespace 'string' already exists
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-01876 : year must be at least -4713
  • ora-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-16126 : loading table or sequence string
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-10266 : Trace OSD stack usage
  • ora-06737 : TLI Driver: connection failed
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-03204 : the segment type specification should indicate partitioning
  • ora-02704 : osndopop: fork failed
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-13518 : Invalid database id (string)
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-14302 : only one list of added-LOB-storage-clauses can be specified in a statement
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-29902 : error in executing ODCIIndexStart() routine
  • 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.