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
OK, I admit it. In 3 years as a DBA I haven't had to deal with a single
LONG RAW column. BLOB, CLOB and BFILE yes LONG RAW, no. So here is my
Monday morning challenge.
I had a database hose itself on Sunday. I rebuilt the database, but it is
still misbehaving (looks like hardware). I can't get a