Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to remove the datafile from data dictionary

Re: how to remove the datafile from data dictionary

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 29 Dec 2004 11:44:33 +0000
Message-ID: <be592d5504122903446134eede@mail.gmail.com>


you have to drop the tablespace to remove it form thedata dictionary - you cannot just wildly drop datafiles

On Wed, 29 Dec 2004 11:10:14 +0800, alex <tech_a_at_126.com> wrote:
> hi,alex
>
> i have some other file in the same tablespace, so i can't just drop the tablespace.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 29 2004 - 05:43:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US