Re: tablespace datafile?
Date: 1998/08/31
Message-ID: <EyKvJ5.GxB_at_news.arco.com>#1/1
First issue the following SQL statement:
ALTER DATABASE DATAFILE 'datafile name' OFFLINE DROP;
Then you can drop the tablespace.
Peter Chan wrote in message <35EAFF7D.264_at_nortel.ca>...
>I removed a datafile that belonged to a tablespace without dropping the
>tablespace first.
>
>Now when I try to drop the tablespace, it complains that the file is
>missing.
>
>How can I work around this, or is it impossible and I have to do a full
>recreate of the database again.
>
>Thanks a bunch!
>
>
>--
>====================================================================
>PETER CHAN, Northern Telecom
>PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
>====================================================================
Received on Mon Aug 31 1998 - 00:00:00 CEST