Re: Question on handling LONG data

In article <4eo28r$gk0_at_news.vcd.hp.com>, tball_at_vcd.hp.com (Terry Ball) writes:
>
> I'm still trying to figure out why ORACLE has LONG data type if it is not
> fully supported.
>
> We have a data base that has several tables with LONG data type. We want to
> be able to duplicate the data base so that long queries can be run against
> a seperate data base to allow the faster response for short, normal queries.
>
> We have been trying to fiqure out how to do this. According to the manuals,
> snapshots are out because ORACLE does not do snapshots of LONG data.
>
> We have tried export/import of a single table. According to the manual, if
> you keep adjusting the buffer size, you will eventually hit the 'magic'
> number that lets the import complete. Well, no matter what number we tried,
> we never found that number.
>
> So, is there any way around this? Does anyone have any work arounds? Any
> help would be appreciated.
>
> Thanks in advance.
>
> Terry Ball

what version of Oracle you have? it seems that we can do import & export for the the long data type just fine. we are runing v6.0.37.6.1 on solaris 2.3 and 2.4.

Also, if your long is not really that 'long'(not like 2G allowed in v7), you could write a C program insert one row a time. I did that to recreate serveal tables we are having , worked fine.

Chris Received on Wed Jan 31 1996 - 00:00:00 CET