Solved

Table Partitions

Posted on 2012-04-12
5
315 Views
Last Modified: 2012-04-27
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
Comment
Question by:pms_reddy1
  • 3
  • 2
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37838606
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
 

Author Comment

by:pms_reddy1
ID: 37841226
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37842113
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
 

Author Comment

by:pms_reddy1
ID: 37855756
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
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37857097
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now