Tyler Muth’s Blog

Technology with a focus on Oracle, Application Express and Linux

Alter table Muth add partition Colin…

Posted by Tyler Muth on October 12, 2008

alter tabe Muth
add partition Colin
weight 4 pounds 13 ounces
length 18 inches
/

begin
  for i in 1..infinity
  loop
    delete from Muth partition Colin where garment = 'Diaper';
    insert into Muth partition Colin ('Milk');
    dbms_lock.sleep(10800);
  end loop;
end;

More pics here if you’re interested.

8 Responses to “Alter table Muth add partition Colin…”

  1. Bunditj said

    Very nice logic, it make me keep smiling. :)

  2. Paulo Vale said

    Congratulations.
    Lots of work waiting for you. It would be nice if it was so simple as the script ;)

  3. Simon Gadd said

    Hi Tyler.

    Very many congratulations to you both. You must be delighted.

    Simon.
    PS. Didn’t know Oracle did shirts in Colin’s size :-)

  4. Congratulations!! Awesome picture!!
    Is the human race evolving? Don’t you think new-borns look more defined than they used to??

  5. Christina Cho said

    Congratulations, Tyler!!
    Colin looks awesome! Welcome to the delightful and rewarding parenthood journey.

    - Christina

  6. Kris said

    Congrats. but you got the scope wrong. I think it’s more like:

    ALTER SYSTEM SET core_dump_dest=’/mnt/diaper/genie’ SCOPE=BOTH;
    alter system switch logfile;
    Alter system set audit_trail deferred;
    alter system quiesce;

  7. Scott said

    Congrats!

    If only the time between diapers were a fixed interval… :)

    - Scott -

  8. Tyler Muth said

    Simon: Well, my shirt is a Miami University (Oxford, OH. We were a school before Florida was a state). His was just something the hospital had. Good idea though, I should try and find an Oracle shirt in his size ;)

    Girl-next-door: That picture was taken almost 2 weeks after he was born. He was born 6 weeks early, so he had to stay in the hospital. I’m not sure if this supports or refutes your theory, as he’s either 2 weeks, or -4 weeks depending on how you want to count.

    Kris: Nice! The “system” scope is a lot more funny.

    Scott: Right now it’s a very fixed interval as he doesn’t cry when he goes in his diaper. We feed him every 3 hours, so we just change him right before we feed him. Those were the instructions of his Dr. as well as a whole crew of amazing nurses in the Special Care Nursery at Sibley, so we’re going with it for now.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>