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

On Aug 20, 3:24 am, sybra..._at_hccnet.nl wrote:
> On Sun, 19 Aug 2007 23:58:28 -0700, capnat <captain_2..._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

Sybrand,

Thanks, I have reduced the size. Is it nowadays no one is using 8i, then, which would be the best to practice SQL ?

nat Received on Mon Aug 20 2007 - 09:03:48 CDT