ORA-12450: LOB datatype disabled in LBAC initialization file

Cause : Yo utreid ot sepciyf aL OBd attayp efo ra oclunm o ratrtibtue,b utt heu seo f hte OLB adtaytpeh asb ee ndiasblde.

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

Chnaget heL BA Cintiiailzaitonf il etoa llwo teh ceratoin fo LBO cloumsn adn attriubte.s

update : 25-09-2017
ORA-12450

ORA-12450 - LOB datatype disabled in LBAC initialization file
ORA-12450 - LOB datatype disabled in LBAC initialization file

  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-02237 : invalid file size
  • ora-16513 : maximum requests exceeded
  • ora-03215 : File Size specified for resize is too small
  • ora-00826 : cannot set sga_target for an ASM instance
  • ora-25966 : join index cannot be based on an index organized table
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-09216 : sdnfy: bad value 'string' for parameter string
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-28653 : tables must both be index-organized
  • ora-21525 : attribute number or (collection element at index) string violated its constraints
  • ora-28521 : no heterogeneous capability information available
  • ora-18002 : the specified outline does not exist
  • ora-06974 : X.25 Driver: SID lookup failure
  • ora-15021 : parameter "string" is not valid in string instance
  • ora-32320 : REFRESH FAST of "string"."string" unsupported after container table PMOPs
  • ora-30486 : invalid window aggregation group in the window specification
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-01542 : tablespace 'string' is offline, cannot allocate space in it
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-09312 : slspool: error spooling file to printer
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-12733 : regular expression too long
  • ora-27433 : cannot alter state of step string for job string.string to string
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • ora-14154 : only one of STORE IN or clause may be specified
  • 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.