Take your index tablespace offline. Copy the datafiles that belong to the tablespace to your new destination. Rename the datafiles to *.old (by renaming instead of deleting the datafiles allows you to recover if you goof). Run sql command ALTER TABLESPACE rename datafile 'OLD DATAFILE' to 'NEW DATAFILE' ; for each datafile in your tablespace. Put the index tablespace online. Check your datafile names from v$datafiles to make sure they all have the path that you want. If everything looks good. go ahead and delete your *.old files.