Insert into Table problem

[sidshu]

Hi ,
It is the best place to get help.So Pl.

I have got data (datalength 190,varchar2)in one table .
When I insert into one table (table-A)of varchar2(242), it got inserted
but when I do for another tableTable-B) having varchar2(243), It says that
" insert value is too long". and does not do.

The max extends for for table-B is 249. Is it something do with this?If yes, How can you increase that. It is in production.

Thanks in advance.

[Oracledba8]

I suppose Theere is Data length Problem.
Either the Destination column length to be increased or the Value need to be truncated before insert.

If Altering table is no Problem issue this in Production

Alter table tabname
Modify(columnnname varchar2(specify the length 250));

Should be fine... Otherwise in Insert statement use
Insert into tabname1
select c1, c2, c3, Substr(c4,1,190), c5 etc... from Tbname2.

The Column that is having Length Problem, in insert use Substr...
Hoep this will help.
Thanks

[sidshu]

The same data gets inserted into one table(Table-A) but not in
another(Table-B).
We need to get whole information so I can not use substring.
I can try by increasing the length to 250

[Oracledba8]

The Only Problem that is evident is the Length Problem, You can check the Max Length befre inserting so that you could od something.

Either Increase the Length, and Make sure that you are not getting Blank spaces... use Trim if 8i Otherwise Use Rtrim(Ltrim(Columnname)) on the Inserted Columns..
Thanks