Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with dropping datafile in tablespace
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?
![]() |
![]() |