Copying tables with Long Raw column and conversion of those columns

IANAL_VISTA · *nix forums Guru Joined: 23 Apr 2005 Posts: 485

bill.brennum@grainger.com wrote in
news:1107555035.994138.28930@g14g2000cwa.googlegroups.com:

bill.brennum@grainger.com · *nix forums beginner Joined: 04 Feb 2005 Posts: 1

Hi,

I am attemtping to copy a table from an Oralce 8.1.7 database to a 9.I
database via a DBLINK. I don't have access to the source server to do
an export. The table has its last column as a long raw(7000). I want
to both copy the table and then to convert the long raw data to a
column type from which I can extract the text only data.

I have tried some suggestions found on the Oracle groups, but with no
luck.

Any and all help would be greatly appreciated.

Google