From: "Winnie Liu" Subject: Re: Simple question: remove a a datafile from a tablespace Date: 1998/09/09 Message-ID: <6t7k2s$4d@sjx-ixn10.ix.netcom.com>#1/1 References: <6soiru$5a8$1@duke.telepac.pt> <6sq0pp$bul@dfw-ixnews6.ix.netcom.com> <01bddb8d$a92ad470$c70c400a@cms_bssup> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: ICGNetcom X-NETCOM-Date: Wed Sep 09 9:20:44 PM PDT 1998 Newsgroups: comp.databases.oracle.server The offline drop command is to put the datafile on hold and tell Oracle that the datafile is going to be recovered later (or drop later). It is a way to open a database which had a corrupted datafile but running in the noarchive log mode. This is the only way to open the database even when you have a corrputed datafile under the noarchive log mode. For archive log, the format is "offline" only. Check the Oracle backup and recovery workshop from Oracle press.. one of the best book for recovery. Winnie Andy Hardy wrote in message <01bddb8d$a92ad470$c70c400a@cms_bssup>... > > >Winnie Liu wrote in article ><6sq0pp$bul@dfw-ixnews6.ix.netcom.com>... >> There is no safe way to remove a datafile from a tablespace. Because >> whenever you add a datafile to the database, even though you know that >> particular datafile is empty, ORacle had already added this file to its list >> when they search for free blocks. So, you cannot use offline drop. The only >> way is to export all the object in that tablespace and then reimport it back >> >That's weird... so what is the offline drop command for? > >Andy