Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop system tablespace datafile
Are there any objects in the new data file?
If so move them, bring the database down open in restricted mode,
delete/remove the datafile.
All should be okay.
"superpeter" <nomail_at_no.com> wrote in message
news:a4vinb$nl7$1_at_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 - 02:41:35 CST