Where to move table spaces for best allocation / best practice ?
(2) Questions in Bold
Windows 64-Bit 10.2.0.3 on a SAN
I have an existing DB instance (PROJECTDB) sharing drives with another new DB instance ( MY_NEWDB)
There is a "K:" drive where Legato will be setup to "backup" the RMAN backup of Oracle DB to tape.
I need to move (MY_NEWDB) Table spaces, temp, indexes, etc.. so it can have it's own set of LUNS, originally there was no space available, and not we've discovered it needs to be moved.
Existing is as follows I pulled from documentaiton: