Export your data. Recreate your database creating the tablespace with
multiple data files striped across the 2 disks. Then import the data back
in.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Wells" <wshammou-NoSpam_at_optonline.net> wrote in message
news:5DiH8.120655$ja.35434960_at_news02.optonline.net...
> Hello All,
>
> Our setup is Oracle 8.1.6 on Sun Solaris. 1 Data table made of 8 Data
files
> spread across 2 disks, 4 datafiles each.
> Disk IO is by far, highest on the first data file. How can I spread the
> load evenly across all data files on both disks.
>
> Thanks very much.
> Wells...
>
>
Received on Fri May 24 2002 - 02:58:54 CDT
