No. Why not just insert into the other table? On 6/30/08, Anurag Verma <anuragdba@xxxxxxxxx> wrote: > I have an Oracle 9i (9.2.0.7.0) database. > > One question on table export. > > Can we export a table and import into another table (which has the same > structure)? > > Both the tables are in the same schema. > > > Thanks, > > > -- > > Anurag Verma, > Database Administrator > ERCOT(Electric Reliability Council of Texas), > Texas 76574 > -- Sent from Gmail for mobile | mobile.google.com Bradd Piontek Twitter: http://www.twitter.com/piontekdd Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd Last.fm: http://www.last.fm/user/piontekdd/ -- //www.freelists.org/webpage/oracle-l