Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Moving LONG RAW data between 2 tables
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
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
![]() |
![]() |