kalpanapai
IS-IT--Management
Hi All,
I have a major problem on Production box, recently we have changed thes erver,
and exported and imported the database to new server from old box. Version is 9.21C on Solaris.
In one table there are 10 fields of datatype LVARCHAR, in export file
(.unl)
the data is present , but when it is loaded to the table the data is
truncated, not all the rows , it has happened very randomly.
To test this , i have created a separate table, and used
LOAD from ...
INSERT INTO command
again the same problem ,it is loaded with trucated data.
Is anybody has come across with the above problem? Is it bcoz of
Datablades?
In the new box we do not have any datablades? Is LVARCHAR anything to
do with Datablades?
Any help would be highly appreciated. As it is on the production i
need to find out the reason, bcoz we are exporting every night with
DBEXPORT command.
If we use dbimport , and if it truncates the data, Is export is
relaible?
Early reply would be much helpful.
Thanks in Advance
Kalpana Pai
I have a major problem on Production box, recently we have changed thes erver,
and exported and imported the database to new server from old box. Version is 9.21C on Solaris.
In one table there are 10 fields of datatype LVARCHAR, in export file
(.unl)
the data is present , but when it is loaded to the table the data is
truncated, not all the rows , it has happened very randomly.
To test this , i have created a separate table, and used
LOAD from ...
INSERT INTO command
again the same problem ,it is loaded with trucated data.
Is anybody has come across with the above problem? Is it bcoz of
Datablades?
In the new box we do not have any datablades? Is LVARCHAR anything to
do with Datablades?
Any help would be highly appreciated. As it is on the production i
need to find out the reason, bcoz we are exporting every night with
DBEXPORT command.
If we use dbimport , and if it truncates the data, Is export is
relaible?
Early reply would be much helpful.
Thanks in Advance
Kalpana Pai