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 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 clean export. The three schemas it holds are small. Therefore I thought I would just write the SQL to copy the schemas to a different DB on a different box. The code works great, until the damn LONG RAW column decended on my plans like the angel of death. This is a 3rd party app (of course).

The COPY command doesn't work and the docs aren't helping. Does anyone have any ideas that would help?

DBA> copy from atg_productivity/xxxxx_at_atgd -
> to atg_productivity/xxxxx_at_DBA -
> insert

dss_scenario_info(ID,SCENARIO_NAME,SCENARIO_STATUS,MODIFICATION_TIME,SDL) -
> using select ID,SCENARIO_NAME,SCENARIO_STATUS,MODIFICATION_TIME,SDL from
dss_scenario_info;

Array fetch/bind size is 1. (arraysize is 1) Will commit after every array bind. (copycommit is 1) Maximum long size is 30000. (long is 30000)

ERROR:
ORA-00932: inconsistent datatypes

TIA,
Todd Carlson
Oracle 8i Certified DBA
Bunge Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: TCarlson_at_bunge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw, John B
  INET: jbshaw_at_ingr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).