Help - Search - Members - Calendar
Full Version: truncate
Oracle DBA Forums > Oracle > Oracle Forum
Vugar
Hi i put delete commant but i would like truncate. how i can do it? how i truncate table, but not with truncate command , with delete command
Florin Aparaschivei
DELETE FROM your_table

without any WHERE clause
dave
QUOTE (Vugar @ Jun 24 2008, 05:54 AM) *
Hi i put delete commant but i would like truncate. how i can do it? how i truncate table, but not with truncate command , with delete command


whyw ould you want to do that - whats wrong with truncate?
burleson
>> Hi i put delete commant but i would like truncate. how i can do it?

Huh? This makes no sense at all.


*****************************************************************
>> how i truncate table, but not with truncate command , with delete command

Well, dropping and re-creating the table does the same thing as truncate, as far as lowering the HWM.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.