Friday, August 26, 2011

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


Description:

Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.

Solution: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options: 1) If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns; 2) Reduce the number of columns in the command and resubmit.

HTH:-)

3 comments:

Zheng junxai5 said...

zhengjx20160428
michael kors outlet clearance
oakley sunglasses
longchamp le pliage
kate spade handbags
michael kors outlet online
fitflops
rolex watches
michael kors outlet
tiffany and co
burberry handbags
christian louboutin outlet
christian louboutin sale clearance
ray ban sunglasses outlet
juicy couture
jordan 6s
kobe 8
michael kors outlet
nike blazers shoes
fitflop clearance
jordan 3s
cheap ray ban sunglasses
kate spade purses
tory burch flats
air max
air max 95
kobe 10
concords 11
adidas outlet store
louis vuitton purses
louis vuitton handbags
rolex watches
cheap ray ban sunglasses
louis vuitton bags
nike store
ray ban sunglasses
coach outlet store online
cheap jordans
ralph lauren outlet
giuseppe zanotti outlet

Zheng junxai5 said...

zhengjx20160428
michael kors outlet clearance
oakley sunglasses
longchamp le pliage
kate spade handbags
michael kors outlet online
fitflops
rolex watches
michael kors outlet
tiffany and co
burberry handbags
christian louboutin outlet
christian louboutin sale clearance
ray ban sunglasses outlet
juicy couture
jordan 6s
kobe 8
michael kors outlet
nike blazers shoes
fitflop clearance
jordan 3s
cheap ray ban sunglasses
kate spade purses
tory burch flats
air max
air max 95
kobe 10
concords 11
adidas outlet store
louis vuitton purses
louis vuitton handbags
rolex watches
cheap ray ban sunglasses
louis vuitton bags
nike store
ray ban sunglasses
coach outlet store online
cheap jordans
ralph lauren outlet
giuseppe zanotti outlet

raybanoutlet001 said...

gucci shoes
ugg outlet
ugg outlet
versace jeans
michael kors handbags
bills jerseys
coach factory outlet
true religion outlet
pandora outlet
polo ralph lauren