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

Next time, when you notice that the file is created in the wrong place, DON'T DELETE IT!!! You can copy the whole datafile to the right directory and then issue this after you bring the tablespace offline:

alter tablespace rename datafile <oldfilename> to <newfilename>

Now as you have remove the file. (I guess you will not have any backup of that particular file!) You have to drop the whole tablespace. I hope that you do frequently do an export on the tables though. All you have to do is the following:

1. mount the database (DON'T OPEN IT!!!)
2. Issue: alter database datafile <...> offline drop; <-this statement ONLY work when you mount the database!! NOt when the database is open!!
3. Open the database
4. drop the whole tablespace and then import those tables back.

Good luck!

Winnie

Tarek Chouman wrote in 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 - 23:24:46 CDT