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

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 21 Aug 2007 09:32:54 +0200
Message-ID: <46ca9536$0$230$e4fe514c@news.xs4all.nl>

"joel garry" <joel-garry_at_home.com> schreef in bericht news:1187648032.717074.96840_at_m37g2000prh.googlegroups.com...

> On Aug 20, 7:37 am, "Shakespeare" <what..._at_xs4all.nl> wrote:

>> "capnat" <captain_2..._at_yahoo.com> schreef in
>> berichtnews: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

>
> Explicitly not supported, explicitly for learning, developers and some
> ISV's.  See 
> http://www.oracle.com/technology/products/database/xe/index.html
> .  The faq notes that there is a free online community forum for
> "support."
>

>>From a post on the forum: "Oracle will wait for 11gR2 to realize new

> XE version."
>
> I'm with those who say it is not a good way for DBA's to learn their
> craft, even though that is trumpeted as a perfect use for it.  You can
> download more appropriate versions for that.
>

OK, I'll put my trumpet back in its case.... no support indeed. From the posts I concluded that OP wanted to learn SQL, and XE is easy to install, and will guaranteed not flood his disks ;-) thanks to the internal limits.
With support I actually meant: you can stilll download it, contrary to 8i. I don't think someone learning SQL will want to pay for a support contract. BTW: is there any form of support for other versions from OTN? (Just a question, not starting a discussion!!!)

Shakespeare

> jg
> --
> @home.com is bogus.
> "The agreement with XE: 'no fee, no support, no patches, no whining' "
> - Hans Forbrich
> 

Received on Tue Aug 21 2007 - 02:32:54 CDT