I have all my table space in one unix partition(/oracle/tablespace/user.dbf, etc)
This partition is full there is no more space.
I am removing certain files to make some space.
I have another partition (/oraexport/home) which has around 40G free space.
Is it possible for me move oracle files and tablespace to this partition.
It is very urgent. Sorry for my english.
1) take the tablespace offline
2) move the datafiles at OS level
3) alter tablespace xxx rename datafile 'olddatafile1' 'olddatafile2'
to 'newdatafile1' 'newdatafile2'
4) take the tablespace online
this works only with non system tablespace because u cannot take system tablespace offline
hope that will help
the other solution is startup nomount ur database and use
alter database move datafile ...
I will try it
Click Here to Expand Forum to Full Width