All Questions
3 questions
0
votes
2
answers
5k
views
Split maxvalue partition in Oracle with new subpartition template
How can I split maxvalue partition in Oracle with new subpartition template.
Or
How can I split maxvalue partition in Oracle and add also add new subpartitions parallely
- 11
1
vote
1
answer
466
views
Can partitioning be bypassed in oracle sql 12c?
I have a table with about 25M rows in partitioned on a time key (month). Inside every partition are about 200K rows.
We use this table in a BI context, meaning that business users query on this table ...
- 167
0
votes
1
answer
38
views
How to Perform Window Partitioning with Conditions (Oracle)
I need to know how to narrow down my partitioning window with a condition. For instance, if I have the following:
SELECT
T1.*,
COUNT(T1.ID) OVER (PARTITION BY ID)
FROM TBL T1
WHERE /* some other ...
- 705