Re: How to create objects in specific data_files ?

Hi

Read the online doc's.
There is an 'ALTER TABLE <table_name>

             ALLOCATE EXTENT 
             (DATAFILE '/u01/<file_name in table's tablespace>')

Good luck
Kugendran Naidoo               

Nemniss wrote:
>
> 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 - 05:44:38 CDT