"dom
is the last, best hope of earth."
-Abraham
Lincoln (1809-1865)
|
Can anyone see an Oracle
record without accessing to Oracle database?
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.
ADDRESS_BLOCK
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, unless you have no other options.
|