Re: Question about Archivemode

If Im a hacker and I log into someones DB, what is the quickest way to make it unuseable? Lets say you have an account with DBA access? I mean the whole database with many tablespaces? IS there one thing you can destroy?

Im trying to convince some co-workers of how easy it would be.

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:ah4r57$edm$1_at_lust.ihug.co.nz...
> 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 - 18:20:19 CDT