Re: OT moment of doubt

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
> --
> http://www.freelists.org/webpage/oracle-l
>



--
http://www.freelists.org/webpage/oracle-l

Other related posts: