| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
 |
 |