ORA-22864: cannot ALTER or DROP LOB indexes

Cause : An attempt was made to ALTER or DROP a LOB index.

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

Do not operate directly on the system-defined LOB index. Perform operations on the corresponding LOB column.

update : 26-04-2017
ORA-22864

ORA-22864 - cannot ALTER or DROP LOB indexes
ORA-22864 - cannot ALTER or DROP LOB indexes

  • ora-13151 : failed to remove exception record
  • ora-06567 : invalid number of values specified
  • ora-00360 : not a logfile member: string
  • ora-13378 : invalid index for element to be extracted
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-32163 : Method called on Invalid Environment type
  • ora-02076 : sequence not co-located with updated table or long column
  • ora-03128 : connection is in blocking mode
  • ora-19958 : potential deadlock involving DIAG process
  • ora-00213 : cannot reuse control file; old file size string, string required
  • ora-23388 : replication parallel push watermark error
  • ora-13837 : invalid HASH_VALUE
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-23384 : replication parallel push string argument out of range
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-03205 : partition name is required when partitioned type is specified
  • ora-22929 : invalid or missing directory name
  • ora-02768 : Maximum number of files is invalid
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-01180 : can not create datafile 1
  • ora-07704 : error in archive text: need ':' after device name
  • ora-12640 : Authentication adapter initialization failed
  • ora-00450 : background process 'string' did not start
  • ora-09260 : sigpidu: error obtaining process id
  • ora-18004 : outline already exists
  • ora-28031 : maximum of string enabled roles exceeded
  • ora-16260 : Waiting to replace partial or corrupt logfile (thread# string, sequence# string)
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-01028 : internal two task error
  • 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.