Re: Dropping a Datafile

In article <344d0b95.70729463_at_news.bctel.net>,

   matts_at_xxxnifcosynergy.com (Matt Southcott) wrote:
>I just cannot find this info in any of my books here I guess this is
>not a usual thing to do. I have done this before but for the life of
>me I can't remember how. I want to drop a datafile that is no longer
>of any use due to political bickering between 2 companies. Please
>tell me how. You can call me names later.

You can not drop just a datafile, you have to drop the tablespace it belongs too also. If you want to remove a datafile from a tablespace, you have to do the following things:

- Export all data in the tablespace
- Drop the tablespace
- Remove the datafiles from the filesystem
- Recreate the tablespace
- Import the data

Stefan.

--
Name      :G.R.S. Deisz
Phone     :+31-50-5855954
E mail    :G.R.S.Deisz_at_PTT-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.