Solved

Table Partitions

Posted on 2012-04-12
5
317 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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to connect SQL Server from my Oracle database? 11 100
Queries 15 40
Component is listed with a Protocol more than once 3 30
PL/SQL Two changes 7 28
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

803 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