Range Partitioning in Oracle

Подписаться 33 тыс.

Просмотров 24 тыс.

50% 1

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

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@TechCoach 5 лет назад

List of all partitioning videos Part 1 : Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m3q4lrE671Y.html Part 2 : Partitioning in Oracle - Performance Basics :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OQ8LXbxLI5g.html Part 3 : List Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-w6kB-90pFa4.html Part 4 : Range partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VBkpI4Ki49Q.html Part 5 : Hash Partitioning in Oracle : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2YxOF_sJMLI.html Part 6 : Composite Partitioning in Oracle :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q_e9IkNtSWc.html Part 7 : Reference Partitioning in Oracle :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p8gNwr6Rtdo.html Part 8 : Local Vs Global Partitioned Index in Oracle 11g : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-t77fyUt8XPw.html Part 9 : Partitioning enhancement in 12 c :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-o_WjapdXiQg.html

@Anjiina_Pinky 4 года назад

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

@TechCoach 4 года назад

Thanks a lot Anjlina Singh for the kind words , The video on Indexing series may help as well :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0X9bbtwTnuE.html

@ahmedalmeshaal8868 4 года назад

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

@TechCoach 4 года назад

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

@thiruardura 2 года назад

Very well explained.Well done.

@TechCoach 2 года назад

Thanks a lot buddy :)

@mdwasim5594 4 года назад

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

@TechCoach 4 года назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oz4TbQwrrOY.html

@user-fg6mz1rh9b Год назад

👍👍

@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

@naziramad6542 3 года назад

Useful for me. thanks

@TechCoach 3 года назад

Thanks Nazir for the kind words.

@devipujitha7150 6 лет назад

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

@TechCoach 6 лет назад

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. ru-vid.com/show-UCoLdaMxhfDgdgIAcRGlUvkg

@sriramjaisankar9121 2 года назад

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 2 года назад

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

@VenkataReddyKallam 6 лет назад

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

@TechCoach 6 лет назад

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

@patrickng6606 3 года назад

Very helpful thanks

@TechCoach 3 года назад

Thanks a lot Patrick for the kind words :)

@basukolur8630 5 лет назад

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

@TechCoach 5 лет назад

I will share it soon

@ramramaraju2221 4 года назад

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

@TechCoach 4 года назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oz4TbQwrrOY.html

@halithsha2975 3 года назад

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 3 года назад

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 3 года назад

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