Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Name from DBA_EXTENTS

628871Oct 29 2008 — edited Oct 29 2008

Hi Experts,

Can you please help me out how to find out the table name from dba_extents.

To be very clear on this, if any block got corrupted and if we want to know what is the table or any other objects resides on that block so that we can move the object.

I have seen that in metalink long back to find out the table name by passing the block id from dba_extents as of now am unable to get it again.

I know sure you guys will be experienced on this. So i need you guys help on this.

Regards,
Siraj.

This post has been answered by 26741 on Oct 29 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2008

Added on Oct 29 2008

#general-database-discussions

16 comments

2,547 views