I have a huge table created from another table by someone and want to delete it. I do not have truncate/drop table right. What would be the best solution. it is in oracle.
Right now i plan to give a simple Delete * from table
Asked
Active
Viewed 56 times
0
-
What is the problem with `delete from table` query? – Vipin CP Aug 09 '16 at 07:03
-
@vipin cp : Deleting from 1Bn record table would probably take hours, even with Exadata – guigui42 Aug 09 '16 at 07:08
-
1@guigui42 Then request to give permission for truncate and perform it :) No other way. – Vipin CP Aug 09 '16 at 07:10
2 Answers
0
if DELETE takes too long for you, and you do no have permission to TRUNCATE or DROP table, then the only solution I see is to Ask your DBA to do it for you !
guigui42
- 2,441
- 8
- 35
- 48
0
Convert the table into a partitioned one, and drop the partition in question. The latter will take seconds.
access_granted
- 1,807
- 20
- 25