first u drop ur datafile by using this command
ALTER DATABASE DTATAFILE .........................OFFLINE DROP
after that
start database in nomount stage
create datafile
and then
alter databse open
ALTER DATABASE DATAFILE .............................ONLINE
or
ALTER TABLESPACE ONLINE.




Reply With Quote