This content has been marked as final. Show 7 replies
Hi, i dont understand your comment about of parallel truncate, do you want truncate a table with parallel option??? or Do you want truncate various tables in the same time?
Sounds like you want to truncate multiple tables simultaneously, or else not wait until one has finished to begin another.
Database operations are serial with some exceptions like parallel queries. Truncate is fast (permanent too), which is why it exists. You could if necessary issue commands to do the truncates using dbms_job or the 10g scheduler or perhaps Java but this would be a lot of work to get just right, especially if you have to wait until the truncate has occured to perform some other action like a reload.
Message was edited by (spelling, content):
A truncate statement is DDL not DML like delete and update. Therefore you will not be able to parallelize the operation.
Other than that, a truncate operation should be relatively fast there should be no need to parallel it even if it's possible.
Send the truncate table command as a dbms_job
Which version of Oracle, and what wait event do you see on the sessions which are blocked ?
Hi, i dont understand your comment about of parallelYes, I want truncate various tables in same times.
truncate, do you want truncate a table with parallel
option??? or Do you want truncate various tables in
the same time?
It seems that the oracle server could only handle one truncate at one time.
This is incorrect.
But as you so far didn't post any error message, other than 'it doesn't work' no one can help you.
Senior Oracle DBA