Re: OT moment of doubt

From: Sinardy <all_about_oracle_at_hotpop.com>
Date: Fri, 17 Jun 2005 12:32:01 +0800
Message-ID: <001101c572f5$884e3d30$0400a8c0@ncs.corp.intads>

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_at_iinet.net.au> To: <Oracle-L_at_freelists.org> Sent: Thursday, June 16, 2005 9:30 AM Subject: RE: OT moment of doubt

> Quoting "Bellows, Bambi" <bbellows_at_usg.com>:
>
> > 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

Received on Fri Jun 17 2005 - 00:37:33 CDT