sql database database-partitioning sql-drop subpartition

How Drop the only subpartition of a partition

While I am deleting subpartitions, one of the partition contains only one subpartition I got an error.

Error: ORA-14629 cannot drop the only subpartition of a partition

Can anyone know how to drop single subpartition of a partition

Solution

If the partition contains only one subpartition, you can drop the partition instead.

In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
output sql data to html with hyperlink
Update all column names to be lowercase
SQL Server pivoting on data without an aggregate
replace or remove characters and then cast to decimal
Export specific rows from a PostgreSQL table as INSERT SQL script
Query to get only numbers from a string
SQL grouping result to half hour
table is specified twice both as a target for INSERT and as separate source of data
SQL to JSON Need Bracket for Array that can have multiple rows
Find all occurrences of Substring and replace it with a special characters
Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
How to do aggregate raw sql with julian date in sqlite (with django)
SQL Merge SOURCE order and OUTPUT order
Notepad++/Eclipse sql code auto-indent option?
Output of update statement does not show correct row number
Map table to exactly one of three
PostgreSQL - ERROR: column does not exist SQL state: 42703
How to force evaluation of subquery before joining / pushing down to foreign server
SQL SELECT TOP 1 FOR EACH GROUP
Convert a date to timestamp in a join with interpolation
How To CAST substring as a DATE
batch update a column using sql
Firebird SQL add empty rows in resultset
How do I cast a timestamp column as a MM/DD/YYYY in BigQuery
Parsing JSON with Oracle SQL without knowing incoming field names
Selecting from random column in PL/SQL
Simple Query to Grab Max Value for each ID
How to programmatically check if row is deletable?