Xref: alice comp.databases.oracle.server:74855 Path: alice!news-feed.fnsi.net!news.idt.net!dispose.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: Unused datafiles Date: Fri, 19 Nov 1999 20:11:48 +0100 Message-ID: <943038777.25412.0.pluto.d4ee154e@news.demon.nl> References: <01bf32a3$bdbb73e0$3e35a99e@gal159a> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 943038777 pluto:25412 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@nl.demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 28 For what is being used and what not, link dba_extents to dba_data_files, or dba_free_space to dba_data_files, link them by tablespace_name and/or file_id, and you will know the answer. You should be able to do an alter database datafile 'xyz' drop, if the file is completely empty. Otherwise... Yes! Hth -- Sybrand Bakker, Oracle DBA Frederic DEBRUS wrote in message news:01bf32a3$bdbb73e0$3e35a99e@gal159a... > Hello there, > > I have a tablespace A composed of 6 datafiles A1 to A6 > but I only use 5% of this tablespace is used so I would like to drop some > datafiles > > Is there a way other then export, drop tablespace, recreate, and import to > do it ? > also how to report which datafiles is used and which is not.... > > Some guideline will be appreciated > > Many thanks, > FreD