OraFAQ Forum: Server Administration » Table created under which datafile

Home » RDBMS Server » Server Administration » Table created under which datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table created under which datafile [message #127779]

Wed, 13 July 2005 05:22

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Plz clear this doubt,

I created a table called abc_01 by the user called u1. u1 users default tablespace is users. But users tablespace has got 5 datafiles called usr1.dbf, usr2.dbf,usr3.dbf,usr4.dbf,usr5.dbf.

Now how do i find under which datafile my abc_01 table has got created?

Praveen.

[Updated on: Wed, 13 July 2005 05:23]

Report message to a moderator

Re: Table created under which datafile [message #127786 is a reply to message #127779]

Wed, 13 July 2005 05:47

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

SQL> SELECT file_name FROM dba_extents e, dba_data_files f
  2  WHERE segment_name = 'DUAL'
  3    AND f.file_id = e.file_id
  4  /

FILE_NAME
--------------------------------------------------------------------------------
/dev/rfb_system_01

Best regards.

Frank

Report message to a moderator