Table name from file#
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Table name from file#

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    Table name from file#

    Is there a way to get table name if we know the file number?

    I have 297, 328, 338, 349, 361 and there are db file sequnetial reads associated with those numbers. How do I find out the table names? Thanks.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to look dba_extents

  3. #3
    Join Date
    Aug 2003
    Location
    Dhahran
    Posts
    33
    If there is more than table in the file you will need the block number as well. Suppose you are reading block 23691 from file 297.

    Select segment_name, owner from dba_extents where 23691 between block_id and block_id + blocks -1 and file_id = 297 ;

  4. #4
    Join Date
    Jan 2001
    Posts
    138
    We don't have data block corruption. So we don't have block numbers in the trace file. We got the wait info. from a trace file.

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The only situation where you can get the table name just from the file number is if that file contains one and only one table.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    As mentioned by Mr Pando pls check dba_extents

    select segment_name from dba_extents where file_id in ( select file# from v$datafile );

  7. #7
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    or

    select distinct segment_name, segment_type from dba_extents where file_id = NNN;

    Where NNN is urs file#

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width