Re: why cannot truncate???

Have you checked beforehand how many extents is the table taking up? Truncating
tables with many extents take a long time because Oracle needs to update data dictionary as it reclaims space from freed extents.

Pei

Chan Wai Tong <cscwt95_at_engsvr.ust.hk> wrote in article <6eojmb$4p3_at_ustsu10.ust.hk>...
>
> I am using oracle 7.1.6.
> I want to import data to a table.
> Before I import data, I would like to truncate the table first.
> I login sqlplus and submit the following SQL.
>
> SQL> truncate table me.mytable;
>
> But no response for a long ... long time.
> Then I try to delete all records from the table.
> I can delete records successfully.
>
> Could anyone tell me the reason??
>
> The table is not a cluster table.
>
> Thank you very much.
>
> Mike CHAN
>
>
>
Received on Sat Mar 21 1998 - 00:00:00 CST