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 : 27-06-2017

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

  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-00073 : command string takes between string and string argument(s)
  • ora-07213 : slgcs: times error, unable to get wall clock.
  • ora-02725 : osnpbr: cannot send break signal
  • ora-25191 : cannot reference overflow table of an index-organized table
  • ora-32832 : failure string trying to acquire administration lock
  • ora-03222 : average row size and row count must be greater than zero
  • ora-26660 : Invalid action context value for string
  • ora-26692 : invalid value string, string should be in string format
  • ora-07272 : spwat: invalid semaphore set id.
  • ora-06951 : Operating system call error
  • ora-01525 : error in renaming data files
  • ora-02050 : transaction string rolled back, some remote DBs may be in-doubt
  • ora-24076 : cannot perform operation string for NON_PERSISTENT queue string.string
  • ora-02189 : ON required
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-14086 : a partitioned index may not be rebuilt as a whole
  • ora-12819 : missing options in PARALLEL clause
  • ora-30032 : the suspended (resumable) statement has timed out
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-13051 : failed to initialize spatial object
  • ora-16783 : instance string not open for read and write access
  • ora-02466 : The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.
  • ora-21526 : initialization failed
  • ora-36630 : (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
  • ora-16953 : Type of SQL statement not supported.
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-28594 : agent control utility: invalid parameter name
  • 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.