Re: Problems with dropping datafile in tablespace

On 1 May 2003 12:05:21 -0700, omar_adebisi_at_hotmail.com (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

If you try to open a control file, all you can see is binary stuff, maybe some text stuff.
You probably cannot edit it safely with a normal text editor. Received on Thu May 01 2003 - 14:50:24 CDT