Version : 11.2.0.2
Platform: AIX 6.1
My first post on this was moved by someone to ASM community . I removed that post and I am posting it here.
Our application tablespace ran out of space and we didn't have any free space left in our Data Filesystem. We had some space left in the Filesystem meant for Archive Logs. Since it was urgent , I added a 10gb datafile to this tablespace BUT in the file system meant for Archive logs. Next day, the sysadmins added space to our data filesystem. Now , we have enough space in data filesystem and we want move the above mentioned datafile to the filesystem meant for storing datafiles .
Currently the data file resides in Archive disk group
/ltmprod_arch/LTMPROD/cmdata07.dbf
I want to drop the above datafile and add it to the Filesystem meant for data : /ltmprod_data
/ltmprod_data/LTMPROD/cmdata07.dbf
What is the cleanest way to do this?
Edited by: Kavanagh on Mar 27, 2012 8:08 AM
Removed the word Disk Group