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@xxxxxxxxxxxxxx]
Sent: Fri 5/20/2005 4:49 PM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: insert into select & datatypes?
 
LOB definitely works, through db_link as well.

Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Friday, May 20, 2005 3:40 PM
To: oracle-l@xxxxxxxxxxxxx
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@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

Other related posts: