Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop system tablespace datafile
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