| How to retrieve current partition position [message #369276] |
Mon, 31 July 2000 13:53 |
Ritu
Messages: 5
Registered: July 2000
|
Junior Member |
|
|
Hello,
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 !!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
