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