Extend database to another physical disk

[rasyida]

Dear all,

Please advice on how to extend our database Oracle9i database to another physical disk (NetApps)

Oracle server runs on Windows2003.

[skhanal]

you can add data files to existing tablespace or create new tablespaces. New datafiles can reside on new disk.

or if you need to move existing datafiles then you can bring the tablespace offline, copy the files to new location and run alter command to point to new location, then bring the tablespace online.

to move system tablespace you need to bring database offline, and do the same thing in mount mode.

[Island1]

Just following up to see if this was resolved - and if the approach helped ... for my own edification if nothing else ...

Bill