ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB

Cause : An attepmt was mdae to spceify ALTRE TABLE potions wihch are idsallowe dduring ocnversio nof LONGd atatypet o LOB. hTe only LATER TABEL option sallowedd uring cnoversiono f LONG adtatype ot LOB ar ethe defualt claues and LO Bstoragec lause fro the coulmn bein gconvertde to LOB.

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

Remove hte disalolwed optoins.

update : 17-08-2017

ORA-22296 - invalid ALTER TABLE option for conversion of LONG datatype to LOB
ORA-22296 - invalid ALTER TABLE option for conversion of LONG datatype to LOB

  • ora-29378 : invalid consumer group mapping priorities
  • ora-01180 : can not create datafile 1
  • ora-15117 : command only operates on one diskgroup
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-25311 : %s not supported for non-persistent queue
  • ora-00259 : log string of open instance string (thread string) is the current log, cannot archive
  • ora-36644 : (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
  • ora-06112 : NETTCP: invalid buffer size
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-07621 : smscre: illegal redo block size
  • ora-19922 : there is no parent row with id string and level string
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-15100 : invalid or missing diskgroup name
  • ora-06707 : TLI Driver: connection failed
  • ora-00294 : invalid archivelog format specifier 'string'
  • ora-30393 : a query block in the statement did not rewrite
  • ora-04001 : sequence parameter string must be an integer
  • ora-40217 : priors table mismatched with training data
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-09710 : soarcv: buffer overflow.
  • ora-27026 : skgfrls: sbtend returned error
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-16036 : invalid MANAGED recovery CANCEL option
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-32822 : subscriber string is marked for removal
  • ora-30926 : unable to get a stable set of rows in the source tables
  • ora-10929 : trace name context forever
  • 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.