Re: Create tables on different files or volumegroups in same tablespace ?
Date: 1996/09/30
Message-ID: <52odva$j9h_at_cf01>#1/1
maro_at_gbg.ifsab.se (Magnus Rosenquist) wrote:
> 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 ?
I prefer to use many tablespaces, one for each big table i want to put
in a particular file.
By that way i also ensure that the next extent(s) will be taken
in that particular file.
You have to care of the storage clause to limit the number of extents.
Alain Chereau
As usual :
statements and opinions are mine and do not necessarily reflect the opinions of my employer. Received on Mon Sep 30 1996 - 00:00:00 CEST