Create tables on different files or volumegroups in same tablespace ?

 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 Received on Wed Sep 25 1996 - 00:00:00 CEST