Re: Drop datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 5 Aug 2001 21:44:03 +0200
Message-ID: <997040651.13384.0.pluto.d4ee154e@news.demon.nl>

"Bernard Bourdon" <bernard.bourdon_at_pi.be> wrote in message news:9kk3nj$eva$1_at_news.planetinternet.be...
> I want to delete an empty datafile that I just created by mistake. I use
the
> command "alter database datafile 'xxx' offline drop". No error, the
datafile
> is offline but is not dropped. What can I do ? Can I modify some system
> tables directly (I would have done that on MS Sql Server in a few seconds)
?
>
>
> Thanks,
> Bernard
>
>
>
>

You can resize the datafile to a few k.
You can of course also always export the associated tablespace, drop the tablespace, recreate it, and import your data. You can modify the dictionary, however this is an extremely rash move, and Oracle won't support you anymore.
Oracle is definitely not SqlServer, and you can't use it by just hacking away.

Regards,

Sybrand Bakker, Senior Oracle DBA

Regards Received on Sun Aug 05 2001 - 14:44:03 CDT