Re: Create tables on different files or volumegroups in same tablespace ?

Magnus Rosenquist wrote:
>
> Hi!
>
> Just trying an example:
>
> If I want to create a table on a specific datafile in the same
> tablespace, all I have to do is to execute :
>
> " alter database datafile '/xxx/xxx.dbf' offline "
>
> for each file that I don't wish the table to be created on.
> When I create the table, it will be located on the datafile that is
> still online.
>
> After I have created the table I bring the rest of the datafiles
> online again.
>
> Any comments ?
>
> Will this work, or must all files be online to perform a 'create
> table' statement. ?
>
> I think I could make this work with an import of a partial database
> as well.
>
> If you have any comments on this, I would greatly appreciate them!
>
> TIA
>
> /Magnus Rosenquist
>
> Magnus Rosenquist
> IFS Sweden AB
> maro_at_gbg.ifsab.se

Try looking into 'alter table allocate extent ' you can specify the datafile then.
If you create the table initially with a small extent size and then prior to population allocate a properly sized extent on another datafile - then voila.

Normal right and privileges apply.

You are enven able to deallocate that portion of the extent which is unused - block boundry limits in effect.

-- 
______________________________________________________________________________
Michael J. Hillanbrand II                                        Dulcian, Inc.
                          Oracle Data Base Administration
Voice: 215-773-7307                                     Fax:    610-277-2966
                              mailto://mjhii_at_erols.com  
Delaware Valley Oracle Users Group              http://www.oug.com/OUG/DEVOUG/
SALTS A104, U.S. Naval Reserve     http://www_salts.icpphil.navy.mil/reserves/