Re: How to create objects in specific data_files ?

You can try to partition the indexes and tables. By doing so you can split the load evenly across the datafiles. Just remember the golden rule: Don't put the table, and it's index on the same drive.

Nemniss

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 Wed Sep 22 1999 - 04:14:48 CDT