I'm sure that is why they don't mention it, but if you are using COTS software, there's a fair chance it will still use LONGs. Jared On 5/24/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote: > > 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 ; > > > > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l