Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: why cannot truncate???

Re: why cannot truncate???

From: S Chavali <nospam_at_iname.com>
Date: 1998/03/18
Message-ID: <350FDF8C.7C54353F@iname.com>#1/1

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

 You will need DROP TABLE privilege to be able to truncate.

-- 
Hope this helps !
Regards,
Srini
(to reply via email, please change "nospam" to "chavali" in my email
address -  :-)  )
Received on Wed Mar 18 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US