I have a TABLE(i.e. LONGDESCRPTION) that has multi-million records WHERE one COLUMNS IS a LONG datatype.
Users have entered such data AS:
'The door should be removed.
Please contact USER.'
I am wanting TO ARCHIVE the data OR should I say place IN a text OR data FILE so that once it is exported to the
file and deleted FROM the main TABLE that I can retrieve the data at a later date back into the table or similar table
with the same appearance as:
'The door should be removed.
Please contact USER.'
In other words, I would like to keep the data appearance with the return lines.
Any ideas?
Thanks,
vandy02
Users have entered such data AS:
'The door should be removed.
Please contact USER.'
I am wanting TO ARCHIVE the data OR should I say place IN a text OR data FILE so that once it is exported to the
file and deleted FROM the main TABLE that I can retrieve the data at a later date back into the table or similar table
with the same appearance as:
'The door should be removed.
Please contact USER.'
In other words, I would like to keep the data appearance with the return lines.
Any ideas?
Thanks,
vandy02