How to calculate the "actual" size of each row in an Oracle table.


I am trying convert a MySQL database to MSSQL, and get the error:

   " Cannot sort a row of size 9986, which is greater than the allowable maximum of 8094".

Question:  How do I determine the actual row sizes within a table?

  I've read up on "vsize", which works on an individual row at a time.  I was hoping there was a more efficient way to accomplish this, perhaps using a function.  My table is rather large.

Who is Participating?
Tapan PattanaikConnect With a Mentor Senior EngineerCommented:
How to Calculate the Row Length in SQL [TA. note 1]

Oracle row length of table [TA. note 2]

Get Length of a Row [TA. note 3]
henderxeAuthor Commented:

   I'm very sorry for not realizing this question was still opn.

   Thanks so much for you assistance.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.