ORA-32842: value for property string cannot be altered

Cause : An attepmt was mdae to aletr a proeprty tha tcannot eb altere.d

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

Retry teh operatoin withotu alterign the inidcated porperty.

update : 19-08-2017
ORA-32842

ORA-32842 - value for property string cannot be altered
ORA-32842 - value for property string cannot be altered

  • ora-22913 : must specify table name for nested table column or attribute
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-13348 : polygon boundary is not closed
  • ora-00267 : name of archived log file not needed
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-29303 : user does not login as SYS
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-36401 : (XSSPROPOTYPE) Property string may only be applied to objects of type string.
  • ora-30751 : cannot disable column string from storing objects of type string.string
  • ora-00394 : online log reused while attempting to archive it
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-13484 : the file format and/or compression type is not supported
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-09983 : skxfidsht: Error shutting down SDI channel
  • ora-32127 : REFs do not belong to any connection
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-01071 : cannot perform operation without starting up ORACLE
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-27049 : unable to seek to and read the last block
  • ora-31199 : Warning in processing file string
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-16207 : Logical standby dictionary build not permitted.
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-26697 : LCR contains extra column 'string'
  • ora-15078 : ASM diskgroup was forcibly dismounted
  • ora-19000 : missing RELATIONAL keyword
  • ora-29965 : The specified binding does not exist
  • 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.