RE: delete from dba_tablespaces

Let's just say that this was incredibly ill-advised and one of the reasons I rant about not going in and changing things in the data dictionary manually.

And yes, he did it, I know the other DBA who had to help out recovering this, he told me about it this morning.

Despite what Steve Adams says, most of us are NOT as familiar with the internals of the data dictionary and the inter-relationships of all the tables as he is.

DO NOT MESS AROUND WITH THIS STUFF! Rachel

>From: Winnie_Liu_at_infonet.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: delete from dba_tablespaces
>Date: Wed, 24 May 2000 12:47:27 -0800
>
>Gee.. you guys are brave!!
>Delete from dictionary table now?!?! :)
>
>I guess that I really valued my rest time and would not risk it against a
>stupid act like delete from dictionary tables!
>
>Winnie
>
>
>
>
>
>Jared Still <jkstill_at_bcbso.com> on 05/24/2000 12:18:04 PM
>
>To: Rahul <rahul_at_ratelindo.co.id>
>cc: "'radu.caulea_at_mediareseaux.com'" <radu.caulea_at_mediareseaux.com>,
> "'Oracle List I'" <ORACLE-L_at_fatcity.com>, "'Oracle List II'"
> <oracledba_at_quickdoc.co.uk> (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
>
>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
>jkstill_at_teleport.com - private
>
>
>
>--------
>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
>
>
>
>
>
>--
>Author:
> INET: Winnie_Liu_at_infonet.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).