Re: Export of Long-Field

If both database will be on line and accessible via SQL*NET, you may consider using a remote database link and build the table as a create table local_table as select * from remote_owner.remote_table_at_remote_link.

You have to create the database link and have the distributed database option installed in the database.

Best of luck, Boroskie(boroskie_at_ix.netcom.com)

In article <6bmmuh$cq$1_at_bsdti6.sdm.de>, dreier_at_sdm.de says...
>
>I need to export a couple of Long-fields from an Oracle-DB. Since these
>fields use the 32k-limit a VARCHAR2 isn't possible. This needs to be done
>since I have to migrate the data from one data-model to another. The manual
>states that it isn't possible to export Long-fields.
>
>The possibility of using Microsoft Access via ODBC could work but I'd rather
>not use it.
>
>Does anyone have a solution for this problem by using Oracle tools or SQL?
>
>Thanks in advance
>Olav Dreier
>dreier_at_sdm.de
>
>
Received on Sun Feb 15 1998 - 00:00:00 CST