Re: why cannot truncate???

Is there another table whic references this one ? if so, truncate/delete it first.
cscwt95_at_engsvr.ust.hk (Chan Wai Tong) wrote:

>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

Mark Zawadzki, late of Waynesboro, Va.
'...there is not a sprig of grass that shoots uninteresting to me.'

                                                 Thomas Jefferson, 1790.