REPOST: Re: Attempt to extend SYSTEM tablespace in Oracle 8i

On Fri, 25 Jan 2002 12:08:30 -0000, "Jon Anthony" <jon.anthony_at_caspiansoftware.com> wrote:

>Thanks for that. I did try that but still got Oracle 600 error.
>In the end, an export, rebuild and import solved the problem.
>Pity there is no drop datafile!!!!!!

Incorrect

alter database datafile '<file_name>' [offline] drop

This does work on single file tablespaces only, however, which is logical.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

• WAS CANCELLED BY =======: From: Sybrand Bakker <postbus_at_sybrandb.demon.nl> Control: cancel <o1a35u8m3m3k8fa87ahb8dsakebgasd8pl_at_4ax.com> Subject: cmsg cancel <o1a35u8m3m3k8fa87ahb8dsakebgasd8pl_at_4ax.com> Date: Mon, 28 Jan 2002 02:02:25 GMT Message-ID: <cancel.o1a35u8m3m3k8fa87ahb8dsakebgasd8pl_at_4ax.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722366

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 12:48:42 CST