RE: delete from dba_tablespaces

Who Wants to be a DBA?

What happens if you did 'delete from dba_tablespaces'?

A) Attempt to save disk space fails
B) DB is trashed beyond repair
C) Get a promotion
D) Have to find a new job

Not on OCP,, yet !!

• Kirti

> -----Original Message-----
> From: Winnie_Liu_at_infonet.com [SMTP:Winnie_Liu_at_infonet.com]
> Sent: Wednesday, May 24, 2000 2:37 PM
> To: Jared Still
> Cc: Rahul; 'radu.caulea_at_mediareseaux.com'; 'Oracle List I'; 'Oracle List
> II'
> Subject: RE: delete from dba_tablespaces
>
> 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)
>
> Subject: 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
> 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
>
>
>
>
>
>
> --------
> 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
Received on Wed May 24 2000 - 14:49:33 CDT