Range Partitioning in Oracle

[@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 :)

[@Nikkocj1238]

First of all thank you very much for the knowlege sharing.I have a range partition in my oracle database (SAP datawarehouse). My boss wants me to reorganize / rearrange the partitions as the archiving SAP job covers only 50Partitions among 75 partitions. SO he suggested me to rearrange. Is it really required to re arrange ? cant we just add the partitions which are not involved in the archiving job and get rid of the space issues.. If it is possible for you to suggest a video of merging or splitting or rearranging existing partitions in oracle db. it will be really helpful for me. Please suggest.

[@TechCoach]

I am not 100% sure what you are trying to achieve here. Can you email me more details on [e-mail]

[@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

[@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

[@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?

[@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

[@basukolur8630]

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

[@TechCoach]

I will share it soon

[@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

[@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.

[@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 :)

[@pankajkharade6936]

most of the projects having a partition based on date values

[@БарзуПарпишоев]

👍👍