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 : 21-08-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-09871 : TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.
  • ora-27503 : IPC error attempting to cancel request
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • ora-13147 : failed to generate MBR
  • ora-28169 : unsupported certificate type
  • ora-32002 : cannot create SPFILE already being used by the instance
  • ora-12639 : Authentication service negotiation failed
  • ora-00475 : TRWR process terminated with error
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-01112 : media recovery not started
  • ora-24102 : invalid prefix for generate_job_name
  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-30953 : XML minoccurs value (string) violated
  • ora-04029 : error ORA-string occurred when querying stringstringstring
  • ora-19260 : XQ0040 - invalid namespace node in element constructor
  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-06530 : Reference to uninitialized composite
  • ora-07631 : smcacx: $EXPREG failure
  • ora-13701 : Snapshot pair [string, string] seems to be specified in reverse order.
  • ora-39753 : unsupported use of subquery in PARTITIONED OUTER JOIN condition
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-02213 : duplicate PCTUSED option specification
  • ora-08433 : invalid picture type in convert raw to number
  • ora-13481 : the destination type is not supported
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-26662 : unable to process STREAMS Data Dictonary information for object
  • ora-16730 : error executing dbms_logstdby.skip_txn procedure
  • 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.