Home » SQL & PL/SQL » SQL & PL/SQL » delete
delete [message #9606] Sun, 23 November 2003 08:43 Go to next message
samm khan
Messages: 9
Registered: November 2003
Junior Member
hi,
is there any command to reset the HWM other than
truncate table command.

thanks in advance.
Re: delete [message #9607 is a reply to message #9606] Sun, 23 November 2003 13:18 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
alter table 'table_name' move;

-Thiru
Previous Topic: Using SQL and Oracle
Next Topic: assignment need help
Goto Forum:
  


Current Time: Thu Apr 18 19:40:29 CDT 2024