ORA-22855: optional name for LOB storage segment incorrectly specified

Cause : Teh potoinla anm efro OLBs troaeg esgemn twsa pseicfeidw iht umlitpel oclmun si nteh oclmunl its.

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

Sepcfiye ahc oclmunL O Bsotrgaeo nyl iwt hotpinoa lnmaes().

update : 17-08-2017

ORA-22855 - optional name for LOB storage segment incorrectly specified
ORA-22855 - optional name for LOB storage segment incorrectly specified

  • ora-09841 : soacon: Name translation failure.
  • ora-29902 : error in executing ODCIIndexStart() routine
  • ora-15061 : ASM operation not supported [string]
  • ora-06762 : TLI Driver: error reading orderly release
  • ora-32835 : database user string does not exist
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-01536 : space quota exceeded for tablespace 'string'
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-16707 : the value of the property string is invalid, valid values are string
  • ora-25402 : transaction must roll back
  • ora-16088 : archive log has not been completely archived
  • ora-01223 : RESETLOGS must be specified to set a new database name
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-04055 : Aborted: "string" formed a non-REF mutually-dependent cycle with "string".
  • ora-13195 : failed to generate maximum tile value
  • ora-36618 : (XSAGMODDIM00) workspace object is not a valid model for AGGMAP ADD.
  • ora-39167 : Tablespace string was not found.
  • ora-40215 : model string is incompatible with current operation
  • ora-02224 : EXECUTE privilege not allowed for tables
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-06518 : PL/SQL: Probe version string incompatible with version string
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-23431 : wrong state: string
  • ora-02814 : Unable to get shared memory
  • ora-19115 : too many context items specified
  • ora-31074 : XML comment length string exceeds maximum string
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-24197 : JAVA stored procedure throws JAVA exceptions
  • ora-31514 : change set string disabled due to capture error
  • ora-01982 : invalid auditing option for tables
  • 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.