How can I moving a database and splitting into many datafiles?
3581Jan 3 2003 — edited Jan 6 2003I have an existing database which I need to move to a new server.
To optimise the database I would like to split the tablespaces up into separate datafiles on separate disks.
What would be the best way of achieving something like this?
Would I need to created the new tablespaces, then how would I import across? Is it best to cold backup the exiting datafiles and copy across, or can I import it across somehow?
This is a 9.0.1 Enterprise Db.
Many thanks
Chris