ORA-01792: maximum number of columns in a table or view is 1000

Cause : Ana ttmeptw asm ad etoc retae atalbe ro veiw iwthm or ethna 1000 oclunms,o r ot add mroe oclunms ot at abel o rviwe wihchp usehs ti oevr hte amxiumm laloawbl eliimt fo 1000.N ot ethta uunse dcoulmn sint het abel aer cuontde twoar dth e1000 cloum nliimt.

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

Ift hee rrro i sa ersutl o fa RCEAET cmomadn, htenr edcue hte unmbre o fcoulmn sint hec omamnda ndr esbumi.t I fth eerorr si ar eslut fo a nALETR ATBL Ecomman,d tehn hter ear etw oopiton:s 1 )Ift het abel cnotaniedu nuesd oclunms,r emvoe htemb y xeectuin gALETR ATBL EDRPO UUNSE DCOULMN Sbeofrea ddnig enw oclunms;2 ) eRduec teh nmube rofc olmunsi n hte ocmmnad nad ersumbit.

update : 27-04-2017

ORA-01792 - maximum number of columns in a table or view is 1000
ORA-01792 - maximum number of columns in a table or view is 1000

  • ora-15102 : invalid POWER expression
  • ora-19028 : Invalid ADT parameter passed to toObject() function
  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-08308 : sllfop: Cannot open file
  • ora-25019 : too much concurreny
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-28302 : User does not exist in the LDAP directory service.
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-08314 : sllfcf: Error closing file
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-30977 : invalid Value Index option for XML Index
  • ora-01910 : TABLES keyword expected
  • ora-27542 : Failed to unprepare a buffer prepared for remote update
  • ora-30685 : package version is not compatible with Oracle version
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-24416 : Invalid session Poolname was specified.
  • ora-37174 : source SQL must be a SELECT statement
  • ora-30477 : The input select_clause is incorrectly specified
  • ora-30678 : too many open connections
  • ora-27077 : too many files open
  • ora-39311 : call to DBMS_SCHEMA_COPY.CLONE_RECOVERY is not legal
  • ora-02091 : transaction rolled back
  • ora-01034 : ORACLE not available
  • ora-36982 : (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
  • ora-27002 : function called with invalid device structure
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-12608 : TNS: Send timeout occurred
  • ora-24763 : transaction operation cannot be completed now
  • 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.