Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!rip!news.webusenet.com!router1.news.adelphia.net!news1.news.adelphia.net.POSTED!not-for-mail From: "Scott Mattes" Newsgroups: comp.databases.oracle.tools References: <11f0f8fa.0306051144.9b772bf@posting.google.com> Subject: Re: Reloading a table Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Fri, 06 Jun 2003 14:10:15 GMT NNTP-Posting-Host: 68.65.40.201 X-Complaints-To: abuse@adelphia.net X-Trace: news1.news.adelphia.net 1054908615 68.65.40.201 (Fri, 06 Jun 2003 10:10:15 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 10:10:15 EDT Xref: core-easynews comp.databases.oracle.tools:59385 X-Received-Date: Fri, 06 Jun 2003 07:09:33 MST (news.easynews.com) Also, depending on what you are trying to accomplish, you could create table my_table_backup as select * from my_table; The do either delete my_table; insert into my_table select * from my_table_backup; OR drop table my_table; create table my_table as select * from my_table_backup; "Michael Kelly" wrote in message news:11f0f8fa.0306051144.9b772bf@posting.google.com... > I wish to create a .sql file I can run to reload a table. Is there a > simple way to dump the contents of a table into an sql format file? In > other words a series of insert statements. > > please respond to miteke@yahoo.com