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 : 25-09-2017
ORA-01792

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-12076 : invalid threshold value
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-27162 : thread creation failed
  • ora-28150 : proxy not authorized to connect as client
  • ora-27141 : invalid process ID
  • ora-32401 : materialized view log on "string"."string" does not have new values
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-32127 : REFs do not belong to any connection
  • ora-21702 : object is not instantiated or has been de-instantiated in cache
  • ora-30159 : OCIFileOpen: Cannot create the file or cannot open in the requested mode
  • ora-29536 : badly formed source: string
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-18008 : cannot find OUTLN schema
  • ora-16803 : unable to query a database table or fixed view
  • ora-01754 : a table may contain only one column of type LONG
  • ora-15181 : Symbol [string] not found in library string, error [string]
  • ora-25113 : GLOBAL may not be used with a bitmap index
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-22337 : the type of accessed object has been evolved
  • ora-01285 : error reading file string
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • ora-00384 : Insufficient memory to grow cache
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-25123 : Too many components specified in the name.
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-31095 : cannot generate string : "string.string" already exists
  • 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.