Oracle block dump
From: Rich <richa03_at_gmail.com>
Date: Wed, 22 Jul 2009 11:20:49 -0700
Message-ID: <26279fb90907221120p3e92e774p2791dedd78db4ef0_at_mail.gmail.com>
Hello List,
Date: Wed, 22 Jul 2009 11:20:49 -0700
Message-ID: <26279fb90907221120p3e92e774p2791dedd78db4ef0_at_mail.gmail.com>
Hello List,
This is 64-bit 10.2.0.4 on 64-bit RHEL 5.1.
I have a DBA which I would like to dump: Block header dump: 0x12703cff
I think this block belongs to a bigfile tablespace.
How do I convert this to a file number and block?
I tried:
select 'file: '||dbms_utility.data_block_address_file(to_dec('12703cff')) ||
' block: '||dbms_utility.data_block_address_block(to_dec('12703cff')) from
dual;
however, this doesn't seem to work for bigfile tablespaces - I got:
file: 73 block: 3161343
File 73 does not exist in this DB...
Thanks in advance,
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 22 2009 - 13:20:49 CDT