Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REALLY urgent : Beginner's dumb question (O7.3)
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
--