Deleted records in table

[mannah07]

I have deleted some records from my table.Now when I run a query the records still show but they are marked as deleted. I want to take them completely from the table. It's new package I am about to deploy.
I have use the ff:
Clear all
clear windows
But none worked. Can I get some help pls.

 

[AirCon]

Try to put SET DELETED ON

-- AirCon --

 

[jimstarr]

To remove them use the PACK command. -Jim

 

[mannah07]

Thanks Jimstarr. It worked

 

[mannah07]

Thank you AirCon