RE: insert into select & datatypes?

LOB definitely works, through db_link as well.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Friday, May 20, 2005 3:40 PM
To: oracle-l_at_freelists.org
Subject: 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 20 2005 - 16:54:31 CDT