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

tim.mcconechy_at_runtime.dk wrote:

> 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...

As mentioned in other post, DBA_EXTENTS will list the FILE_ID in which each extent is stored. Note that subsequent extents may be in different datafiles. I'm not sure why you'd need to control which datafile a table is created into (if it matters that much, you might consider creating a new tablespace with the desired datafile placement), and I don't think you can do it (at least not in 7.3), but once the table is created, you can place additional extents in whatever datafile you wish using the ALLOCATE EXTENT clause of the ALTER TABLE command. Again, I don't know quite what you want to achieve, but by creating the table with a very small initial extent, you can at least get most of the data into the preferred datafile. Hope this helps. Received on Thu Feb 25 1999 - 17:20:33 CST