What's the limit of row size?

[hmcheung]

I'm using Oracle 8i. What is the limit of the size of a row? Is it the same as SQL Server 2000, which the row size limit is the size of a page? Thanks! Please visit my WebCam!!

http://i.am/andycheung

 

[ljspop]

Hi,

I don't remember the exact limit, but there is no limitation like the size of
a page. Oracle will chain big rows across blocks.

Bob Bob Lowell
ljspop@yahoo.com

 

[karluk]

There's probably some theoretical limit, but whatever it is, it's much larger than the page size. Oracle rows don't have to fit into a single page. If the row gets too big it is written to multiple pages. This is called "row chaining". Performance may suffer if there are a lot of chained rows, but other than that you won't notice any difference.

By the way this is one of the rather ugly limitations of SQL Server. In a lot of ways SQL Server and Oracle are comparable, but SQL Server has a few really noticable limitations that it will have to deal with in the next few releases in order to establish itself as a top of the line product.

 

[DBAwhosaysNIE]

uh, they may want to start with fixing their OS so it can stay up for more than ninety days at a time (best I've done on NT & that took considerable patching/tuning). when M$ produces a reliable OS (one of my E450s has an 8.0.5 instance which is >400 days) then maybe I'll look at their tools. even mySQL on Linux (combined cost $0) can go longer than that. not trying to flame but the only thing I see SQL Server & Oracle having in common is that their parent companies are both owned by men with eleven figure net worths they Hoovered from customers' wallets.

just my 2c/never 2bHO...