Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Moving LONG RAW data between 2 tables

Moving LONG RAW data between 2 tables

From: Yigal Ran <ydran_at_usa.net>
Date: 25 May 00 23:02:37 EDT
Message-Id: <10508.106816@fatcity.com>


Does any one have a utility to copy data between two tables with LONG RAW=

  column.

  Insert into ..... Select ... from will fail.

  Copy command will truncate the data in the LONG RAW column

  TIA   Yigal



Get free email and a permanent address at http://www.amexmail.com/?A=3D1

 From: cyhu_at_eachnet.com
 Date: Fri, 26 May 2000 11:00:10 +0800
 Subject: =?gb2312?b?tPC4tA==?= =?us-ascii?q?=3A_?= =?us-ascii?q?SQL?= Help, Please!

DQpUcnkgdGhpcyBzcWwgc3RhdGVtZW50IQ0KDQpTUUw+IHNlbGVjdCBhLmRhdGVvcCxzdW0oYi50 b25zKSBhY2NfdG9ucyBmcm9tIHlvdXJ0YWJsZSBhLHlvdXJ0YWJsZSBiDQogIDIgIHdoZXJlIGEu ZGF0ZW9wPj1iLmRhdGVvcA0KICAzICBncm91cCBieSBhLmRhdGVvcDsNCg0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQ0KQ2h1bnl1IEh1o6xEQkENCrr6tLrT6qOsyv2+3b/iudzA7dSx DQpodHRwOi8vd3d3LmVhY2huZXQuY29tDQpUZWwoTymjujg2LTIxLTUyMzQwODcxLzA4NzIqNjY3 DQpFLW1haWyjumN5aHVAZWFjaG5ldC5jb20NCsirufrD4rfRt/7O8cjIz9+jujgwMC04MjAtNTIx NyjO0rCu0tfIpCkNCg0KobBFYWNobmV0LmNvbSAtIENISU5BJ3MgTEFSR0VTVCBPTi1MSU5FIENP TlNVTUVSIFRSQURJTkcgQ09NTVVOSVRZDQrS18ikzfggLSC49sjLtefX08nMzvHOqtbQufrIy7S0 1OzVuNDCyfq77qGxDQoNCg0KDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K ICAgICAgICAgICAgICAgICAgICBKYW5lIEdhbyAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAg PEpHYW9Aa2FsZ29sZCAgICAgICAgytW8/sjLo7ogICAgIE11bHRpcGxlIHJlY2lwaWVudHMgb2Yg bGlzdCBPUkFDTEUtTCAgDQogICAgICAgICAgICAgICAgICAgIC5jb20uYXU+ICAgICAgICAgICAg IDxPUkFDTEUtTEBmYXRjaXR5LmNvbT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAg ICAgICAgICAgICAgICAgICC3orz+yMujuiAgICAgICAgICAgICCzrcvNo7ogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgcm9v dEBmYXRjaXR5LiAgICAgICAg1vfM4qO6ICBTUUwgSGVscCwgUGxlYXNlISAgICAgICAgICAgICAg ICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgIGNvbSAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgIDAwLTA1LTI2ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAg ICAgICAgICAgICAwODo1OCBBTSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgx+u08Li0ILj4 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQogICAgICAgICAgICAgICAgICAgIE9SQUNMRS1MICAgICAgICAgICAgICAgICAgICAg Received on Thu May 25 2000 - 22:02:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US