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

"capnat" <captain_2010_at_yahoo.com> schreef in bericht news:1187618628.036687.214740_at_i13g2000prf.googlegroups.com...
> 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
>

If your goal is to practice SQL, I would suggest you download 10 g Express Edition (XE). It's still supported (as far as I know) and easy (...) to install and the download is not too large (165Mb). You'll find it on otn.oracle.com. XE has some limitationson memory and data sizes, but will serve your purposes.
You'll have to run it on Windows or Linux, no other platform supported.

Shakespeare Received on Mon Aug 20 2007 - 09:37:37 CDT