Re: How to move objects from one datafile to another?

Eugene schreef:
>
> Thank you all,
> Going back to 8i, would you recommend to MOVE tables and indexes in
> different tablespaces on different drives???
>
> Eugene
>

For no other reason than maintenance - perhaps. Do not expect performance gains, just because you store your indexes on another disk than your tables.

Always use as much spindles as you can lay hands on; spindles == speed

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...