Can anyone pls how to drop a Particular partition in Partition Primary index table.
ex: CREATE TABLE PURU_TAB,FALLBACK(ID INT,NAME CHAR(10),DOB DATE)PRIMARY INDEX(ID)
PARTITION BY RANGE_N(DOB BETWEEN DATE '2014-01-15' AND DATE '2014-08-30' EACH INTERVAL '1' MONTH,NO RANGE,UNKNOWN)
here i want to drop one partition in a table ....how can we drop the partition.
From the above table, I want to create a Partition on ID column.
In partition definition what should i specify in Each interval ?
You can refer to this link for adding and dropping partition:
Be aware of rules too
Rules for Modifying Populated and Unpopulated Tables and Join Indexes
you can add:
If a table is not empty,can we drop a particular Partition.
Thanks for your reply..
There are cases, for that reason I mentioned rules. I do not want to rephrase the words from the doc. The link is provided here:
You could have tried it. Real life time experience is way galaxy far better than anything :).
AS you provided the link, i tried it but I am getting an error.
Eg : ALTER TABLE PPI MODIFY DROP RANGE BETWEEN DATE '2014-01-13' AND DATE '2014-01-31'.If i tried i am getting error
Syntax error,expected something like a 'CHECK' keyword between the 'MODIFY' keyword and the 'DROP' keyword.
Please help me out in this scenario.
Check your syntax properly. Check your table and data properly too. Understand, which data you are going to drop.