ORA-02310: exceeded maximum number of allowable columns in table

Cause : The attributes in the object type column exceeded the maximum number of columns allowed in a table.

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

Specify fewer attributes for the object type and retry the operation.

update : 17-08-2017
ORA-02310

ORA-02310 - exceeded maximum number of allowable columns in table
ORA-02310 - exceeded maximum number of allowable columns in table

  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-07236 : slemop: open error.
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-01043 : user side memory corruption [string], [string], [string], [string]
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-16514 : the request was not found
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-19767 : missing TRACKING keyword
  • ora-25502 : concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running
  • ora-12986 : columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
  • ora-24305 : bad bind or define context
  • ora-01138 : database must either be open in this instance or not at all
  • ora-24165 : invalid rule engine object privilege: string
  • ora-15126 : component within ASM file name 'string' exceeds maximum length
  • ora-16702 : generic resource guard warning
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-02848 : Asynchronous I/O package is not running
  • ora-39018 : master process received invalid message number string
  • ora-06757 : TLI Driver: server got bad command
  • ora-29931 : specified association does not exist
  • ora-01010 : invalid OCI operation
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-06039 : NETDNT: connect failed
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-02794 : Client unable to get key for shared memory
  • ora-00475 : TRWR process terminated with error
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-01042 : detaching a session with open cursors not allowed
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • 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.