Home » RDBMS Server » Server Administration » How to retrieve current partition position
How to retrieve current partition position [message #369276] Mon, 31 July 2000 13:53
Messages: 5
Registered: July 2000
Junior Member

How can I retrieve the current partition position (or number) for a partitioned table (in Oracle 8.0.5)?

To be more specific :
I have a table which is partitioned on date and currently has 7 partitions. In my application, at any given point of time, I have to retrieve records only from the current partition. Is there a way I can do this through SQL or is this value stored in any v$ view or dba table ?

Any help would be appreciated ...
Thanks !!!
Previous Topic: I can't insert CLOB data large than 4k.
Next Topic: dynamic pl/sql
Goto Forum:

Current Time: Mon Dec 05 12:08:14 CST 2022