Table Partitions

What is table partitioning?

Howmany types of partitions are there?

Please provide more details about Hash partitioning,When should we use hash partitioning,
Please provide some examples.

Thanks,
pms_reddy1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
This is like the third very general question you have asked.  Are these homework or exam questions?

Are you not wanting to read the docs?

The 'types' are here:
http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm#autoId17

Hash partitioning here:
http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm#autoId20

The docs even say when it is ideal to use...

Excerpt from the link:  Hash partitioning is the ideal method for distributing data evenly across devices
0
pms_reddy1Author Commented:
Hi,

I know in Oracle site we can get the documents.Since I am working multiple technologies & multiple projects I do not have time to go through the huge volumes of info.

If you already having knowledge on the topics please share with us,It will be helpful for the readers.

Along with the explanation if you can share the reference links it would be well and good,

I hope you can understand the problem.

Thanks,
0
slightwv (䄆 Netminder) Commented:
I'm not sure anyone can provide you with the general overview of what you are asking better than the docs can.  If you need someone to read through documentation and provide sort of an executive summary, I suggest hiring a research assistant.

The different types are partitioning available are right there in the links I provided.  There aren't huge volumes to go through.  Open the link and scan a page or two.

Here is a copy/paste form the first few lines of the first link I posted:
Partitioning Strategies
 
Oracle Partitioning offers three fundamental data distribution methods as basic partitioning strategies that control how data is placed into individual partitions:

•Range
•Hash
•List

Using these data distribution methods, a table can either be partitioned as a single list or as a composite partitioned table:

 •Single-Level Partitioning
 •Composite Partitioning
 
Each partitioning strategy has different advantages and design considerations. Thus, each strategy is more appropriate for a particular situation.
0
pms_reddy1Author Commented:
Is there any way to select the perticular partition in the "where clause" if I want to select the records from partition_1?If so,is that applicable to all of the patition types(Range,Hash,..)
0
slightwv (䄆 Netminder) Commented:
Yes.  The docs have it:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements009.htm#i165979

Example here:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10002.htm#i2105152

>>If so,is that applicable to all of the patition types(Range,Hash,..)

As long as the partition has a 'name', I assume you can select directly from it.  But if you were using a HASH partition, why would you want to?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.