ORA-36154: (XSMXAGGR01) workspace object is not a data variable.

Cause : nAo jbce taw spscefiei dnot ehA ggeragetc moamdnl ni ehttaw san toa v raailbe

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

pScefi y aavirbaeli snetda

update : 24-08-2017

ORA-36154 - (XSMXAGGR01) workspace object is not a data variable.
ORA-36154 - (XSMXAGGR01) workspace object is not a data variable.

  • ora-16530 : invalid buffer or length
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-35026 : (QFCHECK05) The analytic workspace and EIF file definitions of workspace object have a mismatched ALIASOF dimension.
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • ora-07721 : scgcm: not enough OS resource to obtain system enqueue
  • ora-29267 : illegal call
  • ora-31643 : unable to close dump file "string"
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-24364 : internal error while padding blanks
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-24062 : Subscriber table string inconsistent with queue table string
  • ora-40204 : model string already exists
  • ora-13333 : invalid LRS measure
  • ora-38491 : could not evaluate subexpression for rowid "string"
  • ora-29526 : created Java class string"string"
  • ora-01913 : EXCLUSIVE keyword expected
  • ora-06743 : TLI Driver: cannot alloc t_bind
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-16517 : the object handle is invalid
  • ora-19039 : Keyword string reserved for future use
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-16782 : instance not open for read and write access
  • ora-22055 : unknown sign flag value [string]
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-32767 : No server connection for this operation
  • ora-24066 : invalid privilege 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.