Re: Oracle block dump
Date: Wed, 22 Jul 2009 23:54:10 +0100
Message-ID: <B46D5FF7314D44878E4742BC28B77885_at_Primary>
Look at dbms_rowid, rather than dbms_utility.
I haven't read the manual recently but I notice that several procedures have a parameter "ts_type_in", which sounds promising.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message ----- From: "Rich" <richa03_at_gmail.com> To: "Oracle-L Freelists" <oracle-l_at_freelists.org> Sent: Wednesday, July 22, 2009 7:20 PM Subject: Oracle block dump
> 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...
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 22 2009 - 17:54:10 CDT