Hi

I do not want to drop and re-create the table. I just want to clear the table. As there are mnay records inside therefore I would like to use truncate instead of delete.

In the first place, is there a grant truncate in Oracle??

Thanks!