Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extending tablespace TEMP
On Tue, 18 Dec 2001 14:15:22 +0100, Jan Eliasen <eliasen_at_cs.auc.dk>
wrote:
>On Tue, 18 Dec 2001, Niall Litchfield wrote:
>
>> If there was no data in the datafile - and thats a pretty big if - you might
>> get away with 'alter database datafile 'your file' offline drop;'
>Since the file was just added to the tablespace with a size of 1MB and I
>deleted it from the harddrive just after, I don't think there were any
>data in it.
>
>Anyway, I do a;
>sqlplus "/ as sysdba" and run the
>alter database datafile
>'/usr/local/oracle/product/9.0.1/oradata/database/system02.dbf' offline
>drop;
>
>command, and I get a "Database altered." in return.
>
>But next time I try to start up oracle, I get the same error as before. It
>does not seem to work.
>
>--
>Eliasen Jr.
>
Please post the exact error message and the statements you ran. And donīt forget the oracle version and platform. It might help us identifying the problem.
If itīs not a production system get rid of the whole bunch and start again.
Regards
Andy
Received on Tue Dec 18 2001 - 07:31:19 CST