Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
Hello,
I have a table with numpart 5.Below is the display from CA RC QUERY:
part l imitkey logical part
1 2023-6-30 1------oldest month
2 2023-7-31 2------oldest month
3 2023-8-31 3
4 2023-9-30 4
5 2023-10-31 5
I want the first two partitions(oldest months)to be removed,as well as to add two new partition/limitkey appearing at bottom. Expecting to look like the below:
After "ALTER TABLE ADD PART" executed:
part limitkey logical part
1 2023-8-31 1
2 2023-9-30 2
3 2023-10-31 3
4 2023-11-30 4------newly added
5 2023-12-31 5-------newly added
Is it possible to drop first two partition(6th & 7th month)from pbr table? If "YES" ,how can I change logical/physical part to be in sequence -1,2,3,.....after oldest partition gets deleted? |
|
