Oracle
Sponsored Links
This PL/SQL Package allows partition management operation on an Oracle Table.
It provides various features such as:
1)Creating Monthly partition.
2)Creating Daily partitions.
3)Removing Date Partitions
4)Convert a non-partitioned table to a partitioned table
5)Splitting of MAXVALUE partition.
The parameter that needs to be passed and their description are as follows:
Creating monthly partition procedure accepts the following input parameters:
a)Name of the table.
b)Table Alias.
c)Date from which the partition needs to be created.
d)Date upto which the partition needs to be created.
e)Tablespace for the specified table.
Creating daily partition procedure accepts the following input parameters:
a)Name of the table.
b)Table Alias.
c)Date from which the partition needs to be created.
d)Date upto which the partition needs to be created.
e)Tablespace for the specified table.
Removing date partition from a table.
a)Name of the table.
b)Table Alias.
c)Date upto which the partition needs to be created.
Converting a non-partitioned table to a partitioned table.
a)Name of the table.
b)Schema in which the table resides.
c)Column on which the partition needs to be created.
d)Partition alias.
e)Date from which the partition needs to be created.
f)Date upto which the partition needs to be created.
g)Temporary table drop option.
| # | Coder Name | Hits |
| 1. | jamesravid | 37417 |
| 2. | krishnaindia2007 | 31184 |
| 3. | Jim.Anderson | 27783 |
| 4. | Mohit Sharma | 20050 |
| 5. | Beena | 13463 |
| 6. | jainsourabh2 | 8632 |
| 7. | Satheesh | 5677 |
| 8. | SriramKrishna | 4771 |
| # | Coder Name | Codes |
| 1. | jamesravid | 3 |
| 2. | Mohit Sharma | 2 |
| 3. | Satheesh | 1 |
| 4. | jainsourabh2 | 1 |
| 5. | SriramKrishna | 1 |
| 6. | krishnaindia2007 | 1 |
| 7. | Beena | 1 |
| 8. | Jim.Anderson | 1 |
