Resizing or Removing datafiles for tablespace
I'm new to Oracle and was wondering about this -
Platform Windows 2003 64-bit R2, Oracle 10G 10.2.0.3
I would like to know if I have a tablespace with multiple datafiles that span different set of drives. There is data in all the datafiiles
e.g.
Datafile01.dbf 18% full F:
Datafile02.dbf 7% full G:
Datafile03.dbf 1% full H:
Datafile04.dbf 0% full I:
Datafile05.dbf 2% full J:
How do I can delete 1 or 2 datafiles, and still retain the data within each of the datafiles?
I assume for resize I can do it with the DB online/or offline - just being careful no one is on DB during maintenance window.
thank you for your time/help
Thank you