Re: How to create objects in specific data_files ?

alter table <table_name> allocate extent 'datafile';

But that will only force the extent to go where you want it.

You really need to use multiple tablespaces. That is really the best way.

Mirza Mohsin Beg <mbeg_at_netearnings.com> wrote in message news: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 Sat Sep 25 1999 - 17:49:09 CDT