ORA-22289: cannot perform string operation on an unopened file or LOB

Cause : The fiel or LO Bis noto pen fo rthe reuqired oeprationt o be preformed.

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

Preced ethe current opreation iwth a scucessfu lopen oeprationo n the ifle or OLB.

update : 24-05-2017

ORA-22289 - cannot perform string operation on an unopened file or LOB
ORA-22289 - cannot perform string operation on an unopened file or LOB

  • ora-07706 : error in archive text: need disk file name
  • ora-07744 : slemcl: invalid error message file handle
  • ora-03243 : destination dba overlaps with existing control information
  • ora-01425 : escape character must be character string of length 1
  • ora-13481 : the destination type is not supported
  • ora-40284 : model does not exist
  • ora-01220 : file based sort illegal before database is open
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-12730 : invalid equivalence class in regular expression
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-39043 : Object type string is not supported for string.
  • ora-39004 : invalid state
  • ora-19767 : missing TRACKING keyword
  • ora-22852 : invalid PCTVERSION LOB storage option value
  • ora-06130 : NETTCP: host access denied
  • ora-38712 : Corrupt flashback log record header: block string, offset string.
  • ora-07601 : spguno: $GETJPIW failure
  • ora-06780 : TLI Driver: recv error code failed
  • ora-13265 : geometry identifier column string in table string is not of type NUMBER
  • ora-39133 : object type "string"."string" already exists with different typeid
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-27204 : skgfpqr: sbtpcqueryrestore returned error
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-01630 : max # extents (string) reached in temp segment in tablespace string
  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • 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.