Re: [newbie] how to get rid of a datafile

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 16 Feb 2001 09:31:24 GMT
Message-ID: <3a8cf0e8.989764@news-server>

On Fri, 16 Feb 2001 00:29:08 +0100, Jochen <madnecker_at_hotmail.com> wrote:

>
>Is there only 'one' way to get rid of it by removing all data of the
>tablespace to some other place, dropping the entire tablespace,
>recreating it without that 'get-rid-of-it-datafile' and moving the data
>back? (The entire how to move a table from one tablespace to another was
>discussed previously).
>

Yes.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Feb 16 2001 - 03:31:24 CST