Re: Question about Archivemode

You can't drop the system tablespace. Try it, and you'll get an error message to that effect:

SQL> drop tablespace SYSTEM;
drop tablespace SYSTEM
*
ERROR at line 1:
ORA-01550: cannot drop system tablespace

Regards
HJR "Ryan" <rgaffuri_at_cox.net> wrote in message news:a6lZ8.92703$%%2.3951072_at_news2.east.cox.net...
> Also if you drop the system tablespace does it wait for any kind of
instance
> shut down or is it immediate? Im 99% sure its instant, but I need to prove
> something to someone at work and I dont want to be wrong.
>
>
> "Ryan" <rgaffuri_at_cox.net> wrote in message
> news:R4lZ8.92701$%%2.3951689_at_news2.east.cox.net...
> > Ok this is a really basic Backup and Recovery question.
> >
> > If someone drops the system tablespace, ie, an intruder.
> >
> > Is it possible to perform a backup from the redo logs in you are not in
> > archive mode or have any software like RMAN installed? Or do I have to
> > recover from my last cold backup?
> >
> > For those of you who saw an earlier post of mine... no this did not
> happen.
> > :)
> >
> >
>
>
Received on Wed Jul 17 2002 - 17:30:36 CDT