Re: How to create objects in specific data_files ?

Hey all you guys who responded,

   Thanks for your solutions and ideas.

   Here is one idea which no one thought of - will work in Oracle 7.x and 8.x too :

   If you want to create an object in a specific datafile only - simply use the alter datafile <name> offline statement to make all other datafiles offline thus forcing the database to create in the one online datafile.

HTH, Chetan
Bangalore, India

Mirza Mohsin Beg wrote in message <37E8769B.3262FA8A_at_netearnings.com>...
>
>Hi,
>
>I am trying to create several indexes in a single tablespace which has
>several datafiles over different several external drives.
>
>Is there any specific way to make Oracle 8.0.5 create specific objects
>(ie the indexes) in specific datafiles, than having a different
>tablespace per index.
>
>Thanks,
>
>-M
>ps: please email me directly also.
>
Received on Thu Sep 23 1999 - 00:43:20 CDT