move tablespace

[Naeem]

Hello,
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.
Naeem

[armel]

possible :

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 ...

[Naeem]

Thanks Armel
I will try it