Re: Oracle block dump
Date: Wed, 22 Jul 2009 22:19:57 +0200
What are you max files set to for the DB? Any chance it is just below? The this could be a temp file. So if your maxfiles is 70, this would be temp files 3? Is that a possibility in your DB?
On Wed, Jul 22, 2009 at 8:20 PM, Rich <richa03_at_gmail.com> wrote:
> 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,