Problems with dropping datafile in tablespace

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 2 May 2003 09:32:28 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A0052F@lnewton.leeds.lfs.co.uk>

Comment inline ....

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: jhunter_at_iDevelopment.info (Jeffrey Hunter) [mailto:jhunter_at_iDevelopment.info]
Posted At: Thursday, May 01, 2003 1:28 PM Posted To: server
Conversation: Problems with dropping datafile in tablespace Subject: Re: Problems with dropping datafile in tablespace

>> Hello Peter:

>> This is a very common question and the truth is (for now), Oracle
does
>> not provide an interface for dropping datafiles.

Under 9i Oracle has a mechanism for dropping datafiles, however, probably not what the OP requires, but :

drop tablespace xxxx
including contents
and datafiles;

But it's all or nothing. It will only be of use to the OP if there is a single datafile in the tablespace.

<SNIP> Received on Fri May 02 2003 - 03:32:28 CDT