insert into select & datatypes?

Anyone no if any/all Oracle datatypes that are NOT supported by "insert into select...".

How about "insert into select...from t1_at_dblink" over db link?

insert into SCOTT.B_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE_TABLE | LONG_TABLE | RAW_TABLE] select * from SCOTT.A_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE _TABLE | LONG_TABLE | RAW_TABLE] ;

Thanks,

Chris Marquez
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l