Re: Want to delete system02.dbf in oracle 8i Personal

From: <sybrandb_at_hccnet.nl>
Date: Mon, 20 Aug 2007 09:24:51 +0200
Message-ID: <abgic35f9jl0do2ks51cet1740atdq5ckc@4ax.com>

On Sun, 19 Aug 2007 23:58:28 -0700, capnat <captain_2010_at_yahoo.com> wrote:

>Hi all gurus,
>
>A stupid question. How to delete system02.dbf file from Personal
>Oracle 8i.
>By error created system file in personal oracle 8i using dba studio.
>The file name is system02.dbf. Already have system01.dbf
>Want to delete system02.dbf and It is not getting deleted?
>
>I'm stuck and it is consuming lots of space in my computer. Please
>help me to remove this. Just started learning oracle 8i personal.
>
>nat

Not possible. At it's best you can resize the file to 1 blokc (8k), but you can't delete.
Learning a version of Oracle which is in sustained support since January, is IMO silly. Switch to 10g XE.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Mon Aug 20 2007 - 02:24:51 CDT