Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: delete from dba_tablespaces

RE: delete from dba_tablespaces

From: Jared Still <jkstill_at_bcbso.com>
Date: Wed, 24 May 2000 12:18:04 -0700 (PDT)
Message-Id: <10507.106570@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US