Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why cannot truncate???
How about triggers on that table?
What about other tables referencing your table?
On 18 Mar 1998 13:54:19 GMT, 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
>
Kaboel Karso Received on Wed Mar 18 1998 - 00:00:00 CST