Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Empty a table..

Re: Empty a table..

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 27 Aug 1998 20:16:51 +0200
Message-ID: <6s47on$mn3$1@pascal.a2000.nl> 





>What is the fastest way to empty a table with SQL (I do not mean the


easiest


>way !).. I have an Oracle 7.x database.





Fastest, and best as it will return all used space to Oracle:



    truncate table my_table;



Note that there is no way back. Rollback wn't help you, as Oracle will
automatically commit all open transactions.



Arjan.


Received on Thu Aug 27 1998 - 13:16:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US