you can add another storage path. drop this storage path and do a rebalance of all the tablespaces. Temp tablespaces you can create it again in the new path and drop the old one. The drop storage path command does not drop it until all the user tablespaces are removed from that tablespace. After drop storage path do a rebalance and that path is removed after that.or simpler soln is redirected restore.
Last edited by sharaths_81; 04-16-12 at 05:10.
Reason: for more information