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

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.

jg

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