Topic: Database Administration >> What is partitioning ?
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: What is partitioning ? |
| muzu |
Posted: Aug 15, 2007 06:11:49 AM |
Total Post: 37
Joined: Aug, 2007
|
| Can any anyone explain about partitioning |
|
|
 Nehru |
| Posted: Aug 16, 2007 12:27:37 AM |  |
|
Total Post: 43
Joined: Jul, 2007
|
Hi Muzu,
I am trying to explain about "Partitioning" in Oracle just go thru below explanation,
i think you can get some idea about this after going thru this one,
Partitioning enables tables and indexes or index-organized tables to be subdivided into smaller manageable pieces and these each small piece is called a "partition".
From an "Application Development" perspective, there is no difference between a partitioned and a non-partitioned table.
The application need not be modified to access a partitioned table if that application was initially written on a non partitioned tables.
Oracle introduced partitioning with 8.0. With this version only, " Range Partitioning" was supported.
Then with Oracle 8i " Hash and Composite Partitioning" was also introduced and
with 9i " List Partitioning"
Each method of partitioning has its own advantages and disadvantages
and the decision which one to use will depend on the data and type of application.
Also one can MODIFY, RENAME, MOVE, ADD, DROP, TRUNCATE, SPLIT partitions.
Advantages of using Partition’s in Table
1. Smaller and more manageable pieces of data ( Partitions )
2. Reduced recovery time
3. Failure impact is less
4. import / export can be done at the " Partition Level".
5. Faster access of data
6. Partitions work independent of the other partitions.
7. Very easy to use
Types of Partitioning Methods
1. RANGE Partitioning
2. HASH Partitioning
3. List Partitioning ( Only with 9i)
4. Composite Range-Hash Partitioning
5. Composite Range-List Partitioning ( Only with 9i)
Any one let me know if am wrong
Take Care
Bye
Nehru
|
|
|
|
|
| muzu |
| Posted: Aug 16, 2007 03:16:19 AM | |
|
Total Post: 37
Joined: Aug, 2007
|
Thanks for ur reply, Nehru
I just want to know if suppose there is table named as T1 having 4 columns. Partitioning this table T1 in the sense that we are sub-dividing this table T1 into two tables having 2 fields(columns) each.
Please correct my understanding by just giving or demonstrating an example.
|
|
|
|
|
| Nehru |
| Posted: Aug 16, 2007 03:48:43 AM | |
|
Total Post: 43
Joined: Jul, 2007
|
Hi Muzu,
Oracle itself maintains the Partitions
Go thru this example
YOu need not to divide the table into parts
CREATE TABLE SAMPLE_ORDERS
(ORDER_NUMBER NUMBER,
ORDER_DATE DATE,
CUST_NUM NUMBER,
TOTAL_PRICE NUMBER,
TOTAL_TAX NUMBER,
TOTAL_SHIPPING NUMBER)
PARTITION BY RANGE(ORDER_DATE)
(
PARTITION SO99Q1 VALUES LESS THAN TO_DATE(‘01-APR-1999’, ‘DD-MON-YYYY’),
PARTITION SO99Q2 VALUES LESS THAN TO_DATE(‘01-JUL-1999’, ‘DD-MON-YYYY’),
PARTITION SO99Q3 VALUES LESS THAN TO_DATE(‘01-OCT-1999’, ‘DD-MON-YYYY’),
PARTITION SO99Q4 VALUES LESS THAN TO_DATE(‘01-JAN-2000’, ‘DD-MON-YYYY’),
PARTITION SO00Q1 VALUES LESS THAN TO_DATE(‘01-APR-2000’, ‘DD-MON-YYYY’),
PARTITION SO00Q2 VALUES LESS THAN TO_DATE(‘01-JUL-2000’, ‘DD-MON-YYYY’),
PARTITION SO00Q3 VALUES LESS THAN TO_DATE(‘01-OCT-2000’, ‘DD-MON-YYYY’),
PARTITION SO00Q4 VALUES LESS THAN TO_DATE(‘01-JAN-2001’, ‘DD-MON-YYYY’)
)
;
the above example basically created 8 partitions on the SAMPLE_ORDERS Table all these partitions correspond to
one quarter.
Partition SO99Q1 will contain the orders for only first quarter of 1999.
in this example partition is created based on ORDER_DATE
so the date you entered is matching then that will store in that particular partition ok
YOU NEED NOT TO DIVIDE THE TABLE INTO PARTS
Bye
Nehru
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
