Jared, Right, I saw you earlier post/example. I guess Oracle is consider that LONG / LONG RAW is no longer supported? Chris Marquez Oracle DBA -----Original Message----- From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Tue 5/24/2005 2:24 PM To: Marquez, Chris Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: insert into select & datatypes? Unless of course that datatype happens to be a LONG or LONG RAW. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 5/24/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote: > > For those e keeping score at home. > I asked Oracle Support about this subject; > "Oracle Support For ''INSERT INTO...SELECT'' & DATATYPES Over DB Link" > > ======= > ANSWER > ======= > There are no such datatypes which should not be used for "insert into > select" > So, In the statement > Insert into t1 select * from t2 ; > -- //www.freelists.org/webpage/oracle-l