Oracle Magazine, September/October 2017
DBA PERFORMANCE list as a catch all subpartition for the values you havent defined subpartitions for Now lets look at a potential irritant The partition name SYS_ P1095 is systemgenerated and is not intuitive enough to identify it easily as the partition for the SG value So how do you know which partition name to use without constantly checking the USER_ TAB_ PARTITIONS view as you did earlier The extended partition naming convention comes in handy here You dont need to know the name of the partition You can refer to the partition by the value it contains For example to select rows from the partition containing the SG value use the ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 84 following SQL statement select from accounts partition for SG ACC_ NO ACC_ TYPE STATUS_ CODE ACC_ BALANCE 2 S SG 3000 The result shows the rows from the partition containing the SG value without the partition being named explicitly in the SELECT statement You can use this extended naming technique to refer to partitions instead of specific names in any kind of partition management operation not just in SELECT statements For example you can even use extended partition naming to rename partitions If you dont want to call a partition by the extended reference syntax you can rename it to a more appropriate name such as P_ SG Here is how you can rename the partition alter table accounts rename partition for SG to P_ SG
You must have JavaScript enabled to view digital editions.