Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop system tablespace datafile

Re: drop system tablespace datafile

From: superpeter <nomail_at_no.com>
Date: Wed, 20 Feb 2002 15:14:06 +0800
Message-ID: <a4vinb$nl7$1@news.hk.linkage.net>


i creat the extra one datafile in system tablespace beside from the original one, there are two of it in the system tablespace now, i want to drop the extra one datafile in the system tablespace. i am not so stupid to drop the original datafile in system tablespace, hehe..., thank you.

"Tiger Woods" <clintonn_at_meb.co.za> wrote in message news:3c734132$0$228_at_hades.is.co.za...
> You can't.
> If you want to kill you database, then try.
>
> If you are talking about adding a datafile different story altogether....
>
> Let me know what you are actually trying to drop, the system tablespace,
or
> an extra datafile which you created.
>
>
> "superpeter" <nomail_at_no.com> wrote in message
> news:a4vf4u$i9t$1_at_news.hk.linkage.net...
> > how can i drop the datafile file in system tablespace? i create the
extra
> > one and want to drop it later, but the db deny me to do that.
> >
> >
>
>
Received on Wed Feb 20 2002 - 01:14:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US