ORA-31058: cannot modify read-only XOBs

Cause : ReadO-nly OXBs cnanot eb modfiied.

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

Use noly raed opreatiosn on usch aX OB.

update : 27-04-2017
ORA-31058

ORA-31058 - cannot modify read-only XOBs
ORA-31058 - cannot modify read-only XOBs

  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-30436 : unable to open named pipe 'string'
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-27159 : failure setting process scheduling priority
  • ora-24771 : cannot detach, prepare or forget a local transaction
  • ora-19563 : %s header validation failed for file string
  • ora-01016 : This function can be called only after a fetch
  • ora-32312 : cannot refresh a secondary materialized view "string"."string"
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-23415 : materialized view log for "string"."string" does not record the primary key
  • ora-32129 : cannot get information about this column
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-13290 : the specified unit is not supported
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-13213 : failed to generate spatial index for window object
  • ora-39709 : incomplete component downgrade; string downgrade aborted
  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-36704 : (XSRELTBL06) workspace object should be dimensioned by workspace object.
  • ora-02837 : Unable to unlink temporary file
  • ora-12838 : cannot read/modify an object after modifying it in parallel
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-16196 : database has been previously opened and closed
  • ora-00026 : missing or invalid session ID
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-16642 : db_unique_name mismatch
  • ora-29914 : ODCIGETINTERFACES routine does not return required stream version
  • 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.