Re: How to tell which datafile a table is in.

From: XU <xux_at_informa.bio.caltech.edu>
Date: 2 Mar 1999 19:27:07 GMT
Message-ID: <7bhe2b$cqv@gap.cco.caltech.edu>

No, this will NOT work. It cannot really tell you which datafile a table is in. Just think about it... you don't even need to actually try it.

Matthias Gresz (GreMa_at_t-online.de) wrote:

: Wonna try:

: SELECT
: T.OWNER,
: T.TABLE_NAME,
: D.FILE_NAME
: FROM
: ALL_TABLES T,
: SYS.DBA_DATA_FILES D
: WHERE
: D.TABLESPACE_NAME=T.TABLESPACE_NAME
: ORDER BY
: T.OWNER,
: T.TABLE_NAME
: ;?

: HTH
: Matthias

: --
: grema_at_t-online.de

: Es gibt nichts Neues mehr.
: Alles, was man erfinden kann, ist schon erfunden worden.
: Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899
Received on Tue Mar 02 1999 - 13:27:07 CST