This content has been marked as final. Show 5 replies
Remove 'nowait' from the sql statement.
Use this syntax:
TRUNCATE TABLE l_gsm_pop_gprs_e DROP STORAGE;
NOWAIT?? from where?
the syntax is that:
truncate table (table-name) drop storage;
drop storage(optional) is default if u didnt mention in command also it ll work. but nowait shuld not be mention.
Edited by: ITFRESHER on Nov 18, 2009 9:20 PM
You either have to contact your DBA or go through [No-Wait|http://forums.oracle.com/forums/thread.jspa?threadID=897698]