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

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 20 Aug 2007 09:13:47 -0500
Message-ID: <46c99597$0$16274$88260bb3@free.teranews.com>

capnat wrote:
> 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
>

The number of installations of 8i are getting smaller each day. That is because 8i is 3 major versions behind now and DBAs are upgrading to newer versions. There are still some 8i installations out there, but the numbers are shrinking. I would suggest a much newer version to learn on...like 10g or 11g. You'll still be able to do everything you could in 8i, plus more!

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Mon Aug 20 2007 - 09:13:47 CDT