• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

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,
0
pms_reddy1
Asked:
pms_reddy1
  • 3
  • 2
1 Solution
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now