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