Re: Question on handling LONG data

From: Clive Bostock <clive_at_shimmer.demon.co.uk>
Date: 1996/02/03
Message-ID: <EvunUBAu$5ExEwvo_at_shimmer.demon.co.uk>#1/1


In article <4eo28r$gk0_at_news.vcd.hp.com>, Terry Ball <tball_at_vcd.hp.com> 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

Have you tried the COPY command - it may be worth a try.

Good look.

Clive Bostock

Senior Consulant
KPMG (Health Systems) Received on Sat Feb 03 1996 - 00:00:00 CET

Original text of this message