PS : the
alter database datafile 'filename' offline drop;
statement isn't working ???
--
Tarek Chouman
tchouman_at_bigfoot.com
ICQ : 1283296
Cell. : +33660910496
Tarek Chouman a écrit dans le message <6u60so$6d4$1_at_news2.isdnet.net>...
>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 Mon Sep 21 1998 - 12:25:06 CDT
