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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to drop a datafile

Re: How to drop a datafile

From: Francesco Dini <dini.f_at_adr.it>
Date: Thu, 11 Oct 2001 07:09:41 +0000 (UTC)
Message-ID: <984d4b3965f7f7f06cc00b727e650064.26931@mygate.mailgate.org>


My advice is to export the entire datas over that tbls, than drop the tbls and finally drop the dtfl.
Than you can rebuild the tablespace with the correct datafiles you wish. And finally you can reimport datas.
Or you can move every objects on a new tbls and drop the wrong tbls. Be very careful to drop firstly the TBLS and than the DTFL!

There are also tools for reorganizing tbls like Quest ones but they are too much expensive.
Francesco Dini
http://www.francescodini.f2s.com

-- 
Posted from  [195.94.133.5] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Thu Oct 11 2001 - 02:09:41 CDT

Original text of this message

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