Re: Help, extremly urgent (tablespaces)

From: lif <t_at_i.gb>
Date: Tue, 29 Jan 2002 18:58:31 +0100
Message-ID: <a36nmg$1th7$1@news5.isdnet.net>

try to off line the tablespace before
and drop after...

regenerate the dbf file ??
i don't think it's possible without restore

"Jean-Baptiste Jacquemard" <jb.jacquemard_at_pollak-prebon.fr> a écrit dans le 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...
>
> --
> Jean-Baptiste Jacquemard
> ========================
> POLLAK PREBON
> 4, rue de la Bourse
> 75002 PARIS
>
Received on Tue Jan 29 2002 - 11:58:31 CST