@sqldaily
SQL Daily
6 days
Change the partitioning method for an Oracle table with: ALTER TABLE ... MODIFY PARTITION BY ... This can change The partition method (RANGE/LIST/HASH) The partition columns Add/remove subpartitioning Add the ONLINE clause to allow writes to continue while changing
1
6
17

Replies

@sunny_knit
Sunny
6 days
@sqldaily Will this require row movement enabled?
1
0
0
@sqldaily
SQL Daily
4 days
@sunny_knit No - you can run it as shown in the slide without row movement
0
0
0
@PulseInDc
Pulse Media
3 days
San Francisco is suing Big Food, calling ultra-processed foods a public health crisis.
4
2
19
@sqldaily
SQL Daily
2 days
Aggregate functions in #SQL report totals across many rows Common ones are COUNT, SUM, AVG, MAX, MIN Baraa Khatib Salkini explains how these work and how to use them to answer questions like How many orders are there? What's their total sales value? https://t.co/XzJDY1vagB
0
9
27