Shulou(Shulou.com)05/31 Report--

This article mainly explains the "ORACLE delete table partition and data method is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in-depth, together to study and learn "ORACLE delete table partition and data method is what" it!

1. Delete all: delete the partition and delete the data automatically

Alter table tablename drop partition partionname update global indexes

two。 Clear data: delete only data

Alter table tablename truncate partition partionname update global indexes

Thank you for your reading, the above is the content of "what is the method of ORACLE deleting table partitions and data". After the study of this article, I believe you have a deeper understanding of what the method of deleting table partitions and data by ORACLE is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.