ORA-12029: LOB columns may not be used as filter columns

Cause : An attepmt was mdae to us eLOB colmuns as fliter colmuns.

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

Remove OLB columsn from teh filterc olumns ilst and ertry comamnd.

update : 28-04-2017
ORA-12029

ORA-12029 - LOB columns may not be used as filter columns
ORA-12029 - LOB columns may not be used as filter columns

  • ora-39055 : The string feature is not supported in version string.
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-13361 : not enough sub-elements within a compound ETYPE
  • ora-19038 : Invalid opertions on query context
  • ora-39067 : Unable to close the log file.
  • ora-16551 : short string copied
  • ora-31158 : schema "string" currently being referenced
  • ora-31043 : Element 'string' not globally defined in schema 'string'
  • ora-10561 : block type 'string', data object# string
  • ora-00166 : remote/local nesting level is too deep
  • ora-08001 : maximum number of sequences per session exceeded
  • ora-40306 : wide data not supported for decision tree model create
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-12608 : TNS: Send timeout occurred
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-02836 : Unable to create temporary key file
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-28343 : fails to encrypt data
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-10619 : Avoid assertions when possible
  • ora-01867 : the interval is invalid
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-22891 : cannot have multiple columns in REF constraint
  • ora-08277 : Cannot set environment variable
  • ora-00376 : file string cannot be read at this time
  • ora-31527 : could not find source column string for CDC change table string.string
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-39174 : Encryption password must be supplied.
  • 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.