how to get all ROWIDs from a table (without selecting it)?

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 18 Dec 2008 22:26:09 +0100
Message-Id: <A3BE1CE5-65C6-4A0B-A58F-9BA92DC28082@gmail.com>

List,

Does anyone knows a way to get all ROWIDs from an table without selecting it?
My investigations led me to DBMS_ROWID.ROWID_CREATE and DBA_EXTENTS (Note:238272.1 helped me a lot) but now I'm a little stucked. I does not know how to get all used row_numbers for all blocks (which I calculate from dba_extents) to generate all ROWIDs in DBMS_ROWID.ROWID_CREATE.
Even unused blocks are not within reach for me. (But if I would know there are no row_numbers, It would be a strong indication for a unused block).
DBMS_SPACE.UNUSED_SPACE helps to get the High Watermark (I hope, still untested, sorry).

Has anyone any hint how to get the remaining pieces of this puzzle?

thank you in advance,
Martin

-- Martin Berger http://berxblog.blogspot.com

-- http://www.freelists.org/webpage/oracle-l

application/pkcs7-signature attachment: smime.p7s

Received on Thu Dec 18 2008 - 15:26:09 CST

This message: [ Message body ]
Next message: Dennis Williams: "Re: I’m an Oracle ACE Award Winner now !"
Previous message: Syed Sabdar Hussain: "I�m an Oracle ACE Award Winner now !"
Next in thread: Jared Still: "Re: how to get all ROWIDs from a table (without selecting it)?"
Reply: Jared Still: "Re: how to get all ROWIDs from a table (without selecting it)?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message