HomeОбразованиеRelated VideosMore From: Tech Coach

Partitioning in Oracle Explained with Real project Examples : Introduction

285 ratings | 19999 views
This Video series will explain partitioning and its use cases referencing real project examples from different domain. It will explain what when and why of partitioning in a simple but elaborate manner. This is the 1st video which explains why partitioning is required and what are the advantages we gain from it. The following videos will explain when should we do it and how.
Html code for embedding videos on your blog
Text Comments (48)
Ramesh Ch (26 days ago)
How to partitioned existing table with huse data in Oracle 10g in production please provide steps
how to handle ORA-14074 ? in package
Tech Coach (1 month ago)
Can you please post the exact code with the issue?
I have question which I will post on Monday
Tech Coach (1 month ago)
Sure Please take your time. I have a small request , I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. https://www.youtube.com/watch?v=11DK-oyRql0&t=193s
Rama Yaganti (2 months ago)
Very good clear. Thank you very much
An Indian Abroad (2 months ago)
Thanks a lot Rama Yaganti for the kind words. I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it. https://www.youtube.com/watch?v=11DK-oyRql0&t=5s
Sanjay Kundu (2 months ago)
how can i partition based on a uuid in oracle?
Sanjay Kundu (2 months ago)
+An Indian Abroad thanks :) i'm looking for something like this. data => 123e4567-e89b-12d3-a456-426655440000 | col1 | col2 .... 00112233-4455-6677-8899-aabbccddeeff | aaa | zzz... 123e4567-e89b-12d3-a456-426655440000 | abc | yyy .... 00112233-4455-6677-8899-aabbccddeeff | acn | zyc ... i want partition as below. partition 1 --------------------------------------------- 123e4567-e89b-12d3-a456-426655440000 | col1 | col2 .... 123e4567-e89b-12d3-a456-426655440000 | abc | yyy .... partition 2 -------------------------------------------- 00112233-4455-6677-8899-aabbccddeeff | acn | zyc ... 00112233-4455-6677-8899-aabbccddeeff | aaa | zzz... 123e4567-e89b-12d3-a456-426655440000 and 123e4567-e89b-12d3-a456-426655440000 are dynamic so i cant use list.. will hash partitioning be the best choice?
An Indian Abroad (2 months ago)
What kind of partitioning you want sanjay, I am guessing you want to divide the data in equal partitions using the key. I would recommend hash partitoning for that.
Code Tourist (2 months ago)
can we use two columns for partioning, like in second example , data partioned by year , still furthuer partion by region.
Tech Coach (2 months ago)
Thanks a lot mate, I really appreciate it.
Code Tourist (2 months ago)
Tech Coach  watched the order videos and subscribed.
Tech Coach (2 months ago)
Sure please watch this video it should answer your question. https://www.youtube.com/watch?v=q_e9IkNtSWc&index=6&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
Rajan Srivastava (5 months ago)
very very informative and easy to understand, thanks for being a good mentor...I have one query, what are the static and dynamic pruning , which one is default and how they work.
Rajan Srivastava (5 months ago)
Subscribed :)
Tech Coach (5 months ago)
Thanks for the kind words Rajan I will answer your question shortly meanwhile I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
Purna Chandra Nayak (5 months ago)
Just awesome ....Nice Explanation.... Easy to Understand with proper Explanation
Tech Coach (5 months ago)
Thanks for the kind words. I have a small request I am working on this new youtube channel "An Indian Abroad" it will really help me if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
Mohanraj Rudra (5 months ago)
Awesome.. perfect..:)
phani indra (5 months ago)
Can you please share the ppt to this address : [email protected] gmail.com
phani indra (5 months ago)
Tech Coach :Done
Tech Coach (5 months ago)
Sure Phani It may take a lil while but I will send it. I have a small request I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
Sitaram Sahoo (6 months ago)
Hi, While making a series of video on a topic, please mention the sequence either on the beginning of the slide or in the title itself. Thnx
Tech Coach (6 months ago)
Sure Sitaram, I will do that for my upcoming videos. I have a small request I am working on this new channel and would really appreciate if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
Dewangana Gangwar (7 months ago)
Excellent session..
Tech Coach (7 months ago)
Thanks a lot for the kind words. I would really appreciate if you help me in my new Initiative "An Indian Abroad" by subscribing viewing and sharing. https://www.youtube.com/c/AnIndianAbroadd
NishaReetha .M (8 months ago)
Crystal clear explanation, but if you use very simple English, you would get more followers.
Tech Coach (8 months ago)
Thanks a lot for the kind words. I will try to keep it simple in my next videos. Please help me build my new channel by watching, Subscribing and sharing with friends https://www.youtube.com/channel/UCoLdaMxhfDgdgIAcRGlUvkg
modern physco (8 months ago)
I have partition in my table say by year(2011,2012...2018). And i need to update an single row in 2011 partition,and insert a row in 2011 partition , how can i do this.
Tech Coach (8 months ago)
I Would really appreciate if you help me build my new channel by watching subscribing and sharing "An Indian Abroad". https://www.youtube.com/channel/UCoLdaMxhfDgdgIAcRGlUvkg
Tech Coach (8 months ago)
Your DML code does not change for a partitioned table, you can update and insert the way you have done for a normal table.Oracle will take care of the rest
Mangesh Mankar (8 months ago)
Very Crisp ,clear and excellent explanation.Perfectly paced.Keep up the great work.
Tech Coach (8 months ago)
Thanks a lot for the kind words, Please support me in my new channel by watching subscribing and sharing with your friends https://www.youtube.com/c/AnIndianAbroadd
Raghavendran Ramachari (8 months ago)
Very very useful and clear explanation...it matches exactly with my speed of learning...
Tech Coach (8 months ago)
Thanks a lot buddy for the wonderful comment, I am glad it helped.
sagar bodala (9 months ago)
Good session
Tech Coach (2 months ago)
Thanks Sagar Bodala,I have a small request, I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. https://www.youtube.com/watch?v=11DK-oyRql0&t=6s
Davinder Tagore (9 months ago)
I feel partitioning is a complex topic and tough to understand, but you explained it very nicely. Very well put with real time scenarios. Thank you and looking forward to your next videos.
Tech Coach (2 months ago)
I have a small request, I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. https://www.youtube.com/watch?v=11DK-oyRql0&t=6s
Tech Coach (9 months ago)
There is a complete video series on partitioning, I hope you enjoyed all of those videos
Amol Dholam (9 months ago)
Thank you for such excellent explanation. Helps a lot. Please keep uploading more videos. Thanks.
Tech Coach (2 months ago)
Hi Amol, I have a small request, I am working on this new youtube channel and will really appreciate if you watch and subscribe to it. https://www.youtube.com/watch?v=11DK-oyRql0&t=6s
Tech Coach (9 months ago)
Thanks a lot for the kind words Amol. Sure I will upload more soon :)
shravan kumar. v (10 months ago)
Good explanation
Tech Coach (10 months ago)
shravan kumar. v Thanks a lot :)
vinit naik (11 months ago)
Very neatly explained.Looking forward for your upcoming videos. Keep up the good work ahead
Tech Coach (11 months ago)
+vinit naik Thanks a lot for your kind words, I shall the upload the following videos soon

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.