Export of Specific Rows (ugh Long Raw columns)

   Does anyone know of a way to export specific rows from a table, not the entire table? There is one special problem: LONG RAW columns.

   I have looked into copying rows into a temporary table, then exporting that table. The CREATE TABLE ... AS SELECT... seems to be fine for normal tables, but those with a LONG RAW column can't use this syntax. I wrote a PL/SQL procedure to handle copying the BLOBs but this causes large amounts of redo-log and therefore archive-log space to be used. If only the "CREATE TABLE ... UNRECOVERABLE AS SELECT ..." would work for BLOBs !

   Any ideas?

• Doug Anderson Oracle Database Administrator DAtheDBA_at_mindspring.com