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-07-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-09214 : sfdone: I/O error detected
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-28051 : the account is locked
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-09370 : Windows 3.1 Two-Task driver ORACLE task timed out
  • ora-39019 : invalid operation type string
  • ora-07577 : no such user in authorization file
  • ora-30755 : error during expansion of view hierarchy
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-24038 : RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue
  • ora-16545 : unable to get response
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-12920 : database is already in force logging mode
  • ora-28010 : cannot expire external or global accounts
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-32333 : disable table scn update for Materialized view
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-32005 : error while parsing size specification [string]
  • ora-16542 : unrecognized operation
  • ora-30460 : 'string.string' cannot be refreshed because it is marked UNUSABLE
  • ora-00033 : current session has empty migration password
  • ora-25327 : Array size is invalid
  • ora-31615 : routine string received this error: string
  • ora-31530 : could not find published column string for CDC subscriber view string.string
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-28605 : bitmap indexes cannot be reversed
  • 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.