List partitioning in Oracle : Part 3 

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

In oracle 12c , there is option of ‘Automatic’ in partition by list i.e., for any new value for partition key a new partition will be created.

Slowly I am interesting in Partitioning due to your video series. Thanks a Lot, Vivek

Lovely presentation. I’m actually enjoying your videos. Thank you.

Hi Vivek, your videos on Table Partitioning helped me in my recent interview, thanks for the videos.

awesome 100/100 Please keep coming with new vedio based on different topic of DB

I am Ganesh. Your explanations very good. Could you please make a one video for parsing , Adaptive cursor sharing and Sql profile.

Thank you so much again for your very useful video

what if i want to add another partition called 'SA' to the existing list partition?

Hi Vivek, Thanks for sharing the videos. These are really helpful to understand the concepts clearly. Using composite partitioning, can also be one of the possible solutions for the problem statement. Like if we use list-range partitioning, in that case, we can create 3 partitions for 3 countries and for each partition we can further create 14 sub-partitions.

Excellent explanation..very useful

Well explained , my sincere appreciation to your efforts 👏

Can we change the values for one partition later?

thank you,..

Hi Vivek..As you suggest if any list partition will drop global index will be unusable so what should we do to make it usable again ?

Thanks for the explanation!! How we can create partitions dynamically?

What If we use check constraint for region column, is that be good practice sir?

Hi Vivek, I would like to have video on Automatic list and Multi-column list partition

what will happen if the partition key value got updated ? will the physical location of the updated rows get changed ?

Once again very useful video. But as I can see out of these 9 tutorial video, I think sub-partition is not covered. I haven't seen rest of the videos. It will be very helpful if you add all the topics related to partitioning. Thank you.

Sir one doubt, if I'm not using the partition key in my select Sql will degrade my query performance

Hi.Thanks for the video. I have a doubt regarding global index.you said after deleting partition entire global index will b unusable.If there are 4 partitions,i will drop 3 partitions.That time for the remaining 1 partition how the global index will behave?? Wil it b unusable ??

Hi Vivek, Thanks for these tutorials, these are very helpful. One request, if its ok, can you please share PPT of these videos, for quick revision.

number of staff is dynamic. how create partition every staff

What is staging table and how it is different from normal table ? When we need to use staging table and advantage over it on normal table? Please advise Vivek?

List partitioning should be used only when the data to be inserted belongs to a specific key! Else you can use default to map unknown values When and why . Data above 2 gb . When predefined set of discrete values to arrange unorganized data in an organized way

who is watching in 2021?

Good, but you need to speak a little faster.