Maximum Size for a row

Hi All

What is the maximum size allowed for a row in Oracle. In SQL Server 8060 Bytes per row are allowed. Do we have any restriction in Oracle? Also could any one provide me a detail description on the "maximum capacity specifications"  in oracle 9i.

Thanks and Regards
AmbienceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

krznpskCommented:
The maximum # of rows for a table in Oracle 9R2 is 1000, and the limit for VARCHAR2 is 4000 bytes.   In most cases I think you'd have a lot of trouble hitting that limitation...

This link contains some pointers that might help you:
http://dbforums.com/arch/46/2003/4/748050
krznpskCommented:
Here's the reference manual for Oracle 9R2... Look in chapter 4 for all your Database Limit questions.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536.pdf
legendcainCommented:
You may want to check out this feature comparison as well... it's between 9i and SQL Server..

http://databasejournal.com/features/mssql/article.php/10894_2170201_2
AmbienceAuthor Commented:
OK
If I have 1000 columns in a table and each of the column is of varchar(4000) size, It exeeds the 64 kb page size. How does oracle handle this?
johnsoneSenior Oracle DBACommented:
If the size of a single row is larger than a the Oracle block size, then the row is split into multiple blocks.

This causes multiple I/Os to retrieve a single row which can lead to performance degradation.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.