From: "Alexander V. Silantiev" <silantiev@bashkortostan.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: long datatype good?
Date: Sat, 7 Jul 2001 17:07:59 +0600
Organization: ICC Express InterNetNews site
Lines: 23
Message-ID: <9i6qgo$iqo$1@poikc.bashnet.ru>
References: <9i5k8v$d1dg$1@newssvr06-en0.news.prodigy.com>
NNTP-Posting-Host: kmrb.bashnet.ru
X-Trace: poikc.bashnet.ru 994504024 19288 213.24.103.2 (7 Jul 2001 11:07:04 GMT)
X-Complaints-To: usenet@news.bashnet.ru
NNTP-Posting-Date: 7 Jul 2001 11:07:04 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2417.2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200


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@prodigy.net> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:9i5k8v$d1dg$1@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
>
>
>