Re: Problems with dropping datafile in tablespace

From: Jeffrey Hunter <jhunter_at_iDevelopment.info>
Date: 1 May 2003 05:27:47 -0700
Message-ID: <9dfc69b4.0305010427.1669dee6@posting.google.com>

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<n0t1bvkvbap4mstv9afqdnlpcc68na3og6_at_4ax.com>...
> After I did the following:
>
> alter database datafile 'c:\oracle\oradata\db\tools\T1.dbf' offline
> drop;
>
> select file_name, tablespace_name from dba_data_files;
>
> The datafile that I dropped was still shown as part of the
> tablespace. Why is that?

Hello Peter:

This is a very common question and the truth is (for now), Oracle does not provide an interface for dropping datafiles.

I have an article on my website that provides several ways to drop a datafile.

http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_16.shtml

Hope this helps.

Regards,
-- jeff

---

Jeff Hunter
Sr. Database Administrator
http://www.iDevelopment.info

---

Received on Thu May 01 2003 - 07:27:47 CDT