RE: delete from dba_tablespaces

You really did this?

This was a junk database I hope.

If not, you WILL need to restore.

And if you don't have a backup...

Jared

On Wed, 24 May 2000, Rahul wrote:

> you should try truncating next time.....:))
> but seriously.... i suggest you RTFM first
> before you do any DML/DDL on data dictionary.
>
>
> > ----------
> > From: Radu Caulea[SMTP:radu.caulea_at_mediareseaux.com]
> > Reply To: radu.caulea_at_mediareseaux.com
> > Sent: 24 Mei 2000 11:43
> > To: oracledba_at_quickdoc.co.uk
> > Subject: delete from dba_tablespaces
> >
> > Hello,
> >
> > I hit recently
> > delete from dba_tablespaces (as internal ;-))
> > To my astonisment, everything was really gone, no error or other
> > message. Commited the work. ts$ also messed up. Shortly after I began
> > receiving ora-00600. Is this a normal behaviour (8.0.5 EE NT) ?
> >
> > Regards, Radu Caulea
> >
> >
> > --
> > Radu 'kernel' Caulea, http://perso.club-internet.fr/caulea/
> > alternate eMail: caulea_at_usa.net (will always forward)
> > ICQ: 49088510
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Wed May 24 2000 - 14:18:04 CDT