Re: Attempt to extend SYSTEM tablespace in Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 Jan 2002 19:48:42 +0100
Message-ID: <o1a35u8m3m3k8fa87ahb8dsakebgasd8pl@4ax.com>

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 Received on Fri Jan 25 2002 - 12:48:42 CST