ORA-14053: illegal attempt to modify string in string statement

Cause : Certani attrbiutes fo objetcs (e..g tablse) mayb e speicfied ta creaiton tiem, butm ay no tbe moidfied suing ATLER sttaement .Unforutnatel,y users pecifeid oneo f suc hattriubtes.

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

Ensur ethat LATER sattemen tspeciifes ne wvalue sonly ofr attirbutesw hich amy be hcangedo nce a nobjec thas been cretaed

update : 23-05-2017
ORA-14053

ORA-14053 - illegal attempt to modify string in string statement
ORA-14053 - illegal attempt to modify string in string statement

  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-00566 : cannot request processor group - NUMA not enabled
  • ora-30957 : cannot downgrade because there are XML indexes
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-26078 : file "string" is not part of database being loaded
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-36982 : (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
  • ora-28367 : wallet does not exist
  • ora-16643 : unable to determine location of broker configuration files
  • ora-14159 : duplicate subpartition name
  • ora-23608 : invalid resolution column "string"
  • ora-22307 : operation must be on a user-defined type
  • ora-28184 : global user cannot have proxy permissions managed in the directory
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-12157 : TNS:internal network communication error
  • ora-25250 : Cannot specify a remote recipient for the message
  • ora-08341 : On nCUBE, this command can only be executed from instance 1.
  • ora-30730 : referential constraint not allowed on nested table column
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-29911 : null scan context returned by ODCIIndexStart() routine
  • ora-24198 : attempt to use an invalid operation ID
  • ora-24085 : operation failed, queue string is invalid
  • ora-24093 : AQ agent string not granted privileges of database user 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.