Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REALLY urgent : Beginner's dumb question (O7.3)
Use the command:
> alter database datafile '<filename>' offline drop;
I believe this is it.
Then recreate the tablespace if needed.
I hope this helps!
Tarek Chouman wrote:
>
> Hi,
> Could someone help me with this ?
>
> I created an additional datafile in my tablespace (2 datafiles).
> I then noticed that this file was created in the wrong place on my AIX.
> I removed it using "rm".
> My tablespace is offline.
> How can I delete the logical reference Oracle has on the datafile
> which doesn't exist anymore ?
> My tablespace cannot be shifted to online (everybody is shouting at me)
> because the datafile I removed doesn't exist and I cannot find any statement
> to remove the datafile from Oracle's internal tables.
> Please help :-O
>
> --
> --------------------------------------
> Tarek Chouman
> tchouman_at_bigfoot.com
> ICQ : 1283296
> Cell. : +33660910496
Received on Thu Sep 24 1998 - 12:03:40 CDT