ORA-10662: Segment has long columns

Cause : Shirnkw asi sseud no as egemntw it hlogn cloumsn. hTisi s ont uspprote.d

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


update : 30-04-2017

ORA-10662 - Segment has long columns
ORA-10662 - Segment has long columns

  • ora-29836 : failed to validate referenced operators
  • ora-24163 : dblink is not supported in rules engine DDLs
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-38422 : invalid datatype for the attribute: string
  • ora-40304 : invalid classname string in prior probability specification
  • ora-09919 : Unable to set label of dedicated server
  • ora-10259 : get error message text from remote using explicit call
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • ora-03002 : operator not implemented
  • ora-30752 : column or table string is not substitutable
  • ora-13453 : GeoRaster metadata layer error
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-08182 : operation not supported while in Flashback mode
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-28267 : Invalid NameSpace Value
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-09843 : soacon: Archmon unable to create named pipe.
  • ora-19657 : cannot inspect current datafile string
  • ora-02038 : define is not allowed for array type
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-39601 : Hash key is required.
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-22628 : OCIAnyData already constructed
  • ora-29964 : missing ADD or DROP keyword
  • ora-37027 : (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
  • ora-02855 : Number of requests is less than the number of slaves
  • ora-30513 : cannot create system triggers of INSTEAD OF type
  • ora-13126 : unable to determine class for spatial table string
  • 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.