Re: Help, extremly urgent (tablespaces)

Jean-Baptiste writes:
"Jean-Baptiste Jacquemard" <jb.jacquemard_at_pollak-prebon.fr> wrote in message news:3C56E01D.F26B21B2_at_pollak-prebon.fr...
> Hi all,
> I need to drop a tablespace but the associated file were stupidly deleted.
> When I do :
> drop tablespace MY_SPACE including contents
> I got :
> ORA-01116: error in opening database file 8
> ORA-01110: data file 8: '/oracle/OraHome1/dbs/MY_SPACE.dbf'
> ORA-27041: unable to open file
>
> How can I drop it ?
> Or is it possible to regenerate the file ?
> Thanks for your help...
>

 If you want to drop datafiles here are the quick steps: shutdown database (may be abort)
startup mount
alter database datafile 'file' offline drop alter database open
However if you are running in archivelog mode and you have all archives in place , it is possible to recreate the datafiles and do the recovery.. hth
santysharma Received on Tue Jan 29 2002 - 12:02:49 CST