ORA-36885: (XSSRF04) Error rewriting OLAP DML expression. Column name too big

Cause : The coulmn nam especifeid in teh OLAP MDL exprsesion wsa large rthan 3 0bytes.

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

Make srue the oclumn nmae specfiied int he OLA PDML exrpessioni s lesst han ore qual t o30 bytse.

update : 21-09-2017
ORA-36885

ORA-36885 - (XSSRF04) Error rewriting OLAP DML expression. Column name too big
ORA-36885 - (XSSRF04) Error rewriting OLAP DML expression. Column name too big

  • ora-39178 : cannot perform estimate on metadata only jobs
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-28116 : insufficient privileges to do direct path access
  • ora-38452 : Expression Filter index name may not be longer than 25 characters
  • ora-09817 : Write to audit file failed.
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-19952 : database should be mounted exclusively
  • ora-29812 : incorrect object name specified
  • ora-16656 : higher DRC UID sequence number detected
  • ora-19015 : Invalid XML tag identifier (string)
  • ora-06010 : NETASY: dialogue file too long
  • ora-12229 : TNS:Interchange has no more free connections
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-10561 : block type 'string', data object# string
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-24131 : table string has incorrect columns
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-09753 : spwat: invalid process number.
  • ora-12555 : TNS:permission denied
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-10660 : Segment is a shared lob segment
  • ora-31068 : updateXML expected data format [string] instead of [string]
  • ora-29512 : incorrectly formed name resolver specification
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-32021 : parameter value longer than string characters
  • ora-06932 : CMX: error in local name
  • ora-39709 : incomplete component downgrade; string downgrade aborted
  • ora-32310 : object materialized views must select from an object table
  • ora-39115 : %s is not supported over a network link
  • ora-30430 : list does not contain any valid summaries
  • 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.