Table in which datafile ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Table in which datafile ?

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Table in which datafile ?

    Hi,
    If i have a two datafiles in a tablespace, is it possible to find out in which datafile my table is created.

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: Table in which datafile ?

    Originally posted by bang_dba
    If i have a two datafiles in a tablespace, is it possible to find out in which datafile my table is created.
    DBA_EXTENTS.File_Id column will give you datafile number.

    Sameer
    Last edited by Sameer; 10-30-2002 at 08:10 AM.

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    but it may be in both if there is more than 1 extent.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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