Having multiple varchar2 columns in a single table

[acpreddy]

Hi All,
Wanted to know whether we can have multiple varchar2(2000) columns in a single table? I created a table which has around 30 columns which are varchar2(2000) columns but some of my senior coleagues told me that we can\'t have as it gives problems if we have large amount of data. But I was not convinced with the answer he gave me but wanted to know from the experts whether it was correct or not. The solution given to me was to split the single table into many tables even though it has one to one relation ship. Can someone explain me how this works? I am writing a J2EE application which requires this. Please provide me the links where it gives me some inofrmation on this. Please respond to this ASAP.

Thanking You,

With Regards,
A.Chandra Prasad Reddy.

[sanereddy]

Hello there,

I don\'t see any reason for this. Please find out exactly what kind of problems it causes. You can have any number of columns with any length, that\'s why we are using Databases like SQL Server , oracle where you can enable full text searching feature if we have to search in that kind of fields. I am not sure about the reson for splitting the table into 30 columns, all are varchar2 with 2000 lenght, it does not make any sense for me. You can try using Long datatype.

Thanks,

Post edited by: sanereddy, at: 2005/01/31 23:05

[acpreddy]

Hi,
The reason I got from my seniors on this is due to \"row migration or chaining\" in Oracle. I am not sure of that concept but what they told me is like this. Whenever we want to update the table which have many varchar2, then the system will copy that particular row it seems. As the total size for that particular row is more, If the table space / blocks is small or occupied then it will take very long time to update sometimes more than a day it seems. So Inorder to avoid that they asked me to split it up.

Thanking You,

With Regards,
A.Chandra Prasad Reddy