Range Partitioning in Oracle

In this video I have explained what is range partitioning along with it's 2 real project use cases.
I have also explained interval Partitioning as an extension of Range partitioning
If you have not watched my Initial Videos on partitioning I will recommended watching them before watching this video
Apologies for the 10 second video glitch between 6 and 7 minutes :(
#RangePartitioning #OraclePartitioning #TechCoach

[@TechCoach]

List of all partitioning videos Part 1 : Partitioning in Oracle : kzbin.info/www/bejne/o2TUZZ-oeptqZ7s Part 2 : Partitioning in Oracle - Performance Basics :kzbin.info/www/bejne/hYKbfYuYrbF8a8k Part 3 : List Partitioning in Oracle : kzbin.info/www/bejne/rWfOc2BvZdV5l5Y Part 4 : Range partitioning in Oracle : kzbin.info/www/bejne/jHPOoXxqgM5nb7M Part 5 : Hash Partitioning in Oracle : kzbin.info/www/bejne/aIrbgHmVqK-Agqs Part 6 : Composite Partitioning in Oracle :kzbin.info/www/bejne/p5DIanyhg9mGjcU Part 7 : Reference Partitioning in Oracle :kzbin.info/www/bejne/pmnKf6qoa7enmtE Part 8 : Local Vs Global Partitioned Index in Oracle 11g : kzbin.info/www/bejne/qmial6yLqZ2Lhtk Part 9 : Partitioning enhancement in 12 c :kzbin.info/www/bejne/pZC6m5Smmb2ch8k

[@Anjiina_Pinky]

Very good Tutorial and explained in a easy manner. All video on partition are very easy to understand and wonderfully presented. It help.

[@TechCoach]

Thanks a lot Anjlina Singh for the kind words , The video on Indexing series may help as well :) kzbin.info/www/bejne/Zomck5WqrLmhq6c

[@thiruardura]

Very well explained.Well done.

[@TechCoach]

Thanks a lot buddy :)

[@ahmedalmeshaal8868]

Thank you very much for your simple illustration. Really it is very useful...

[@TechCoach]

Hi Ahmed, Thanks for the kind words. I have a complete series on partitioning which may interest you :)

[@mdwasim5594]

thanku we used this as a reference during our training ........

[@TechCoach]

I am glad Wasim I could be of any help. I have a small request, I am working on this new channel please do watch share and subscribe to it. Your support is my motivation. kzbin.info/www/bejne/hauXhZWHrNelhbs

[@rafiabbasi1]

I have a partition table and data is mapped based on the partiton, i have also created a max value partiton as well, but how can i map max value data into the specifed partiton, means how i create new partiton on that table so that the data which are in max value can also go their respective partition,.

[@TechCoach]

You should opt for interval partitioning or dynamic range partitioning with user defined names

[@user-fg6mz1rh9b]

👍👍

[@sriramjaisankar9121]

Hi Sir, Your videos are amazing to learn. I have a doubt in INTERVAL Partitions. Suppose, We have MARCH as current month, I am getting few records on JUNE month. In That case, new partition will be created. Can we Update the data present in JUNE month now itself?

[@TechCoach]

Ya sure , you will have a new partition for the month of the June

[@naziramad6542]

Useful for me. thanks

[@TechCoach]

Thanks Nazir for the kind words.

[@patrickng6606]

Very helpful thanks

[@TechCoach]

Thanks a lot Patrick for the kind words :)

[@devipujitha7150]

Will range partitioning drop old partitions too? How to make partition as read-only

[@TechCoach]

You have to explicitly drop the partitioning it won't be dropped automatically. From 12c you can make Individual partitions and sub partitions as read only which was not the case with earlier versions, you can use the alter command to make the partition read only. Please support me in my new channel by watching sharing and subscribing. kzbin.info/door/oLdaMxhfDgdgIAcRGlUvkg

[@pankajkharade6936]

most of the projects having a partition based on date values

[@VenkataReddyKallam]

how do we do partition for a timestamp column with 15 days past and 10 days future?

[@TechCoach]

Can you explain a little more? Do you want to do this every 10 days?

[@basukolur8630]

How do you create daily partition on number column , syntax pls.

[@TechCoach]

I will share it soon

[@ramramaraju2221]

Incase of interval partitioning ,for every new partition there will be new segment ..?

[@TechCoach]

Yes ramaraju you are right. I have a small request, I am working on this new channel please do watch and subscribe to it. Your support is my motivation. kzbin.info/www/bejne/hauXhZWHrNelhbs

[@halithsha2975]

I tried creating partition for a table with date(for each day) . whenever the new date is inserted in table partition name is coming as SYS_4325 . But we want partition name is format "P_currentdate" ex: P_2020209 . I am using oracl11g. is there way to define partition name pattern

[@TechCoach]

Is there a specific reason why you want your partition to be named in a particular format? You can create a job and schedule it in daily baiss that generates partition for the next day even before the data is inserted. But why name in a specific format?

[@halithsha2975]

@@TechCoach its my requirement that partition name should be in this format like P_20201015. Is there a way to do it oracle 11g.