RE: insert into select & datatypes?

Yeah,
Don't get me wrong...I have had no issues. But someone is questioning the valdidty of this data movement approach. "Is (Oracle) support"???
I have tested with XMLTYPE...seems fine.

Chris

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

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Fri 5/20/2005 4:49 PM
To: Marquez, Chris; oracle-l_at_freelists.org Subject: 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:59:26 CDT