oracle partition active condition on table
<p>I have oracle query that i want to analyse. The table <code>track_table</code> has <code>active</code> partition. I dont have that much knowledge about partitioning. I want to check on what conditions this partitioning has been created. To check whether my table is partitioned or not i used below query and it says the <code>PARTITION_NAME</code> is active for <code>track_table</code> table. </p>

<pre><code>SELECT * FROM dba_tab_partitions WHERE table_name = 'track_table'; 
</code></pre>

<p>Below is the query which i want to analyse:</p>

<pre><code>select count(*) as cnt 
from track_table partition (active) 
where trg_id &gt; 198754
      and status not in (2);
</code></pre>