Oracle Magazine, September/October 2017
DBA PERFORMANCE state_ code varchar2 2 acc_ balance number partition by list state_ code acc_ type automatic partition ct_ s values CT S ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 88 Now lets insert a row into this table insert into accounts values 2 S NY 8000 Note that NY is the value in the STATE_ CODE column There is currently no partition for this value but as you saw earlier Oracle Database will create new partitions for the values found in new rows and will place the rows in their appropriate partitions You can confirm that by selecting from the partition As you learned earlier there is no need to get and use the exact name of the system generated partition You can refer to the partition by the extended partition name syntax select from accounts partition for NY S ACC_ NO ACC_ TYPE STATE_ CODE ACC_ BALANCE 2 S NY 8000
You must have JavaScript enabled to view digital editions.