Hi friends,
I gave a command to truncate a partitioned table containg almost a billion records. Its almost 45 minutes but still the process is going on.The table was partitioned in to 45 partitions(based on range) and each partition was further subpartitioned into 256 based on a hash
Can someone tell me how much time should it take to truncate? For another table I used directly the drop command, but again this also is in the same state( i mean the command still seems to be executing)
My database is 8.1.6 (parallel server )on a compaq tru-64.
Also, how to confirm that the trucate or drop actions are being performed successfully? I tried v$transaction,but it does not have any info. Even the alert file, I think will get the information once the action is completed.
Thanks
manjunath


[Edited by manjunathk on 05-08-2001 at 06:17 PM]