Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
Hello,
I have a PBR table with part 1 to 5.The logical & physical part order appeared in sequence (1 to 5) when I checked in RC QUERY ('PL' option) before I did rotate partition.
::BEFORE::
part limitkey logicalpart
1 31-05-2023 1
2 30-06-2023 2
3 31-07-2023 3
4 31-08-2023 4
5 30-09-2023 5
After below alter is issued,the order appeared like this
alter table tablename rotate partition first to last ending at ('xxx') reset;
::::AFTER::::
part limitkey logicalpart
1 31-10-2023 5
2 30-06-2023 1
3 31-07-2023 2
4 31-08-2023 3
5 30-09-2023 4
But the order looks different with same alter (same process)in other subsystem :
::AFTER::
part limitkey logicalpart
1 30-06-2023 1
2 31-07-2023 2
3 31-08-2023 3
4 30-09-2023 4
5 31-10-2023 5
I did testing with small table,but couldnt find why limitkey & logical part goes to top in order in one subsystem & bottom in other subsystem.
Any idea/help? |
|
