各位大侠: 请问:如何用简单的SQL语句备份含有LONG RAW域的数据库表格???对于没有LONG RAW域的表格用下面的语句即可:CREATE DATABASE LINK db_link
CONNECT TO user IDENTIFIED BY password
USING "database2"insert into table1@db_link
select * from table1但是,如果table1中含有LONG RAW域,上面的insert语句就无法执行了,不知可有其它好的替代办法???
CONNECT TO user IDENTIFIED BY password
USING "database2"insert into table1@db_link
select * from table1但是,如果table1中含有LONG RAW域,上面的insert语句就无法执行了,不知可有其它好的替代办法???
insert into table1@db_link select to_lob(longraw) from table1
select to_lob(col1) from table1用to_lob
还是报错:非法使用 LONG 数据类型???????????
create table table1 as select to_lob(col1) from table1试试