Solved

Table Partitions

Posted on 2012-04-12
5
328 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 77

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 77

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 77

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

636 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