Create Table On Existing Datafile
I want to create a table and force the initial extent to be allocated from the free space of an existing datafile that's already part of a tablespace. I know how to use "alter table" to allocate extents to an existing table and force those extents to be on the existing datafile, but the "create table" creates the table's initial extent, and I don't know how to confine that initial extent to a specific datafile. If there are other datafiles in the tablespace, then the initial extent apparently may come from free space in any of the available datafiles.