Re: OT moment of doubt
- From: "Sinardy" <all_about_oracle@xxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 17 Jun 2005 12:32:01 +0800
With 10g worry nomore
Just find out this feature today...
--------------------------------------
SQL> create table mytab(col1 char(1));
Table created.
SQL> insert into mytab values('a');
1 row created.
SQL> commit;
Commit complete.
SQL> drop table mytab;
Table dropped.
SQL> select * from mytab;
select * from mytab
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ ---------------
----
MYTAB BIN$ilvlEeJ4Rr6eTVj3yP9djQ==$0 TABLE
2005-06-17:12:28:56
SQL> flashback table mytab to before drop;
Flashback complete.
SQL> select * from mytab;
C
-
a
SQL> show recyclebin
SQL>
--------------------------------------
regards,
Sinardy
----- Original Message -----
From: "Nuno Souto" <dbvision@xxxxxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Sent: Thursday, June 16, 2005 9:30 AM
Subject: RE: OT moment of doubt
> Quoting "Bellows, Bambi" <bbellows@xxxxxxx>:
>
> > But, remember the old saying "life as a DBA is 98% boredom interspersed
> > with 2% sheer panic", well, that moment is just part of the 2% of your
> > job that is worthwhile. =20
>
> Yeah. I used to play a trick on the trainee dbas at my previous job.
> Ask them to get rid of "those old database files there", then sit
> next to them and watch the proceedings. One second after they hit
> the return key on the "rm", I'd shout in with "Oh shewt!".
>
> Guaranteed I'd be peeling them off the ceiling...
> <g,d&r>
>
> Cheers
> Nuno Souto
> from hazy Sydney
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
