LONG datatype problem

[Vandy02]

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

 

[LKBrwnDBA]

Use export utility.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Vandy02]

Hmmm,

Can I use a where clause with that?

If not my only other option is to find a way to put it into another table where I can insert with LONG datatype which causes errors.

 

[LKBrwnDBA]

Only if you have version 9i or more:

exp scott/tiger TABLES=emp QUERY=\"WHERE job=\'SALESMAN\' and sal \<1600\"



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb