| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to drop a datafile
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.ORGReceived on Thu Oct 11 2001 - 02:09:41 CDT
![]() |
![]() |