Re: Problems with dropping datafile in tablespace

Ah, the wonderful world of lessons learned. As you now know, Pro's do not experiment on production systems.

Simon Adebisi wrote:

> jhunter_at_iDevelopment.info (Jeffrey Hunter) wrote in message news:<9dfc69b4.0305010427.1669dee6_at_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
> > ============================
>
> Jeff:
>
> When I deleted the datafile, the SCN was affected but I came up with a
> workaround. I restored the file from the recycle bin. Now my question
> is (relating to the workaround), what file editor does Oracle support
> for editting control, redo and data files? It doesn't have to be
> extravagant as I only have to change the header info...
>
> If you would hurry on the response I would appreciate it since my
> manager is breathing down my neck about this system being down (it's
> our production financials and mfg)....Would notepad or wordpad work?
>
> - Simon
Received on Fri May 02 2003 - 18:57:27 CDT