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

tim.mcconechy_at_runtime.dk schrieb:
>
> How can I tell which datafile a table is created into...
>
> Can i control this.
> I hvae windows NT
> but would like to know the answer for UNIX too.
>
> I thought it was v$sqlare but can't seem to extract the datafile name...

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 Thu Feb 25 1999 - 06:25:26 CST