list
ORACLE-L
rofit.com>cc:
Sent by: Subject: RE: Long Raw Problems
try using a database link, at one time (can't remember which version) there
was a bug that didn't allow copy on long/long raw over a net.
-Original Message-
Sent: Monday, April 02, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
OK, I admit it. In 3 years as a DBA I haven't had
Todd,
You can't use Insert Into...As Select From... with Long or
Long Raw columns.
One solution that I've used is to write an anonymous PL/SQL
block that loops through a cursor on your source table,
capturing each source row in a PL/SQL record, then Inserting
into your target table using the Val