dropping datafiles
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/05/18
Message-ID: <3pg2oc$hsb_at_ixnews4.ix.netcom.com>#1/1
Date: 1995/05/18
Message-ID: <3pg2oc$hsb_at_ixnews4.ix.netcom.com>#1/1
Is there any way to drop datafiles from a tablespace short of dropping the entire tablspace? I have a whole bunch of datafiles that were added to the "system" tablespace (a few hundred meg) with objects that have been created in them. I'd like to recreate the objects in the "users" tablespace and clean up "system". How can I do it?
According to the Server Concepts Manual for version 7, it can be done. But I haven't figured out how yet.
-- Chuck Hamilton chuckh_at_ix.netcom.com Incoming fire has the right of wayReceived on Thu May 18 1995 - 00:00:00 CEST