Can anyone see an Oracle record without accessing to Oracle database?

By: John Kazerooni

Yes. You can only do this if you are using UNIX.

Do the following steps:

Go to sqlplus and get information about where the record is in your Table.

SQL> SELECT dbms_rowid.rowid_block_numer(rowid) address_block

2        FROM your_table

3        WHERE column_name = ‘Your select condition.’

4        /

This query will return the block number of the record that you

are interested to see.

1652

Now since you know the exact location of that record, do the

following steps:

·         Add 8 more blocks to that address (1652 + 8 = 1660).

·         Now, your record is in block position 1660 on that data file.

·         Use dd command with ibs parameter (block size) to skip 1660 block.

# dd if=/u01/oradata/your_database/your_datafile.dbf ibs=8192 \

 skip=1660 count=1|strings

We strongly advise you not to use this.

Good Luck!