Re: rollbacks

On Fri, 14 Apr 2006 08:11:16 -0700, Mark D Powell wrote:

For tables defined in locally managed tablespaces a drop table sends
the table to the recycle bin rather than actually drops the table data
at the time of command. Depending on tablespace free space
availability and extent allocation activity you might be able to
"undrop" the table.


That is, of course, true, unless the DBA did not turn recyclebin parameter
to "off". It is turned on by default, but there are DBAs who turn it off
in order to prevent the annoying two commands needed to drop an object.
Personally, I would never turn it off on a production database, but I do
turn it off on development databases to save space. Drop means "sayonara,
kiss it goodbye", no 2nd chance to get it back. If someone accidentally
drops something on production, I do want a chance to bring it back. If
somebody accidentally drops something on a small development database, I
don't necessarily care too much. Guess where is the vast majority of DDL
commands executed. Tables are like people: if you kill them, they don't
necessarily rise back. If they do, people talk about it for milenia after
the event takes place.

--
http://www.mgogala.com

.

Relevant Pages

  • Re: recycle bin not showing C: drive
    ... Make sure that something is in the Recycle Bin. ... > the D and E drive properties. ... > If I run the commands again it works fine but if not what I delete goes ... > started happening since I ran those attrib comands at the C prompt. ...
    (microsoft.public.windowsxp.general)
  • Re: recycle bin not showing C: drive
    ... >> Make sure that something is in the Recycle Bin. ... >> Kelly (MS-MVP) ... >> Troubleshooting Windows XP ... >>> If I run the commands again it works fine but if not what I delete goes ...
    (microsoft.public.windowsxp.general)
  • Re: c: ecyclerS-1-5-21-129_ ... Dc775.zip
    ... Empty the recycle bin for that account - better still, ... and dir commands with the appropriate command-line switches (like "dir ...
    (alt.comp.anti-virus)
  • Re: recycle bin not showing C: drive
    ... > If I run the commands again it works fine but if not what I delete goes away ... > started happening since I ran those attrib comands at the C prompt. ... If the subfolder is missing, you can find its name in the registry: ... more than one such subfolder in the recycle bin if more than one user ...
    (microsoft.public.windowsxp.general)