SQL Language (MOSC)

MOSC Banner

Sort order on partition, but not within partition

edited Nov 8, 2012 5:52AM in SQL Language (MOSC) 6 commentsAnswered
Hello,
We need to collect data from a table with multiple partitions but in a very specific order. Actually the needed data is spread over 2 of about 90 partitions. In the first of the 2 partitions (in fact in our case the p_null partition: partition key is NULL, containing only a few thousand records), essential header data is loaded (to be precise: this header data contains several headers, describing the content of the data contained in all the other partitions). In the second millions of related data records exist. 
We now want to retrieve first the header record from the first partition (filtered on a documentnumber) and then all records from the second partition. The order in which the data is retrieved from the second partition is irrelevant.  If it is retrieved in the wrong order, so header data somewhere in between normal data, a dependent process which relies on this right order will fail.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center