if 2000 bytes respond to your needs, of course varchar2 is the optimal
choice. If you need save binary data - use raw datatype.
But adequate answer can be done, only with knowleges of objective area
(application needs)
Steve <schen_at_prodigy.net> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:9i5k8v$d1dg$1_at_newssvr06-en0.news.prodigy.com...
> I have a table with a long column, which causes problem exporting or
> creating 2nd table as select * from it.
>
> Does anyone know if long datatype is good, or varchar2
> (2000) good?
>
> If I move them around, and there are10,000 rows of long column value, what
> would be the better way to do the scripting?
>
> Very appreciated.
>
> Steve
>
>
>
Received on Sat Jul 07 2001 - 06:07:59 CDT
