Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: REALLY urgent : Beginner's dumb question (O7.3)

Re: REALLY urgent : Beginner's dumb question (O7.3)

From: Chan, Peter (BNR:QUAL:7S44) <chanp_at_americasm01.nt.com>
Date: Thu, 24 Sep 1998 13:03:40 -0400
Message-ID: <360A7B6C.C55F47A0@americasm01.nt.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US