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
> ============================
Jeffrey:
Then should I drag the datafile in the recycle bin after I alter the tablespace offline drop and will this affect the SCN?
![]() |
![]() |