ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

Cause : The objcet canno tdefine acolumn ni LIMITMPA most lkiely becuase it i sof a wrnog type usch as, ofr exampel, a Worskheet.

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

Remove hte refernece fromt he LIMIMTAP.

update : 29-06-2017
ORA-36871

ORA-36871 - (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.
ORA-36871 - (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

  • ora-39173 : Encrypted data has been stored unencrypted in dump file set.
  • ora-24318 : call not allowed for scalar data types
  • ora-23622 : Operation string.string.string is in progress.
  • ora-38488 : attribute set already assigned to the column storing expressions
  • ora-22971 : invalid datatype for PRIMARY KEY-based object identifier
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-13118 : invalid node_id [string]
  • ora-31404 : all input parameters are null
  • ora-08315 : sllfrb: Error reading file
  • ora-16041 : Remote File Server fatal error
  • ora-38794 : Flashback target time not in current incarnation
  • ora-16124 : transaction string string string is waiting on another transaction
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-29807 : specified operator does not exist
  • ora-29326 : SET COMPATIBILITY release number higher than string
  • ora-23491 : no valid extension request at "string"
  • ora-28024 : must revoke grants of external roles to this role/user
  • ora-24381 : error(s) in array DML
  • ora-27009 : skgfwrt: cannot write to file opened for read
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-13024 : polygon has less than three segments
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-25953 : join index cannot be a functional index
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-01938 : IDENTIFIED BY must be specified for CREATE USER
  • ora-16782 : instance not open for read and write access
  • ora-01272 : REUSE only allowed when a file name is provided.
  • ora-30115 : error when processing an environment variable
  • ora-06547 : RETURNING clause must be used with INSERT, UPDATE, or DELETE statements
  • ora-38469 : invalid privilege for an expression set: string
  • 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.