07 March 2011

How Do I Do That? - Installing a pks, pkb file

"S" before "B" when using the "P".

Just when I was feeling a little more secure in tidbits of knowledge, I got a request from a client today.

From: Client
To: Kim

Please run a simple SQL statement in Production.

"Okay", I thought, "Here goes!".  It was easy! I ran it! No fear!  Then I got another request two minutes later.

From: Client
To: Kim

 Please run these two attachments.

[attachments: ThingOne.pkb; ThingOne.pks]

OH MY GAWD!

What were THEY?  What was I supposed to DO with them?  Was I supposed to RUN them? Was I supposed to import them into a schema?  I have never seen things with these extensions before!  Yah, again, people -  wonder at my ignorance.  It's pretty vast.

Okay, Google is my friend.  You know what?  pks and pkb files are all over the place in the Google, but they don't tell you what to do with them. They just tell you bugs and issues. Thank GOD I have Sr. DBA R.

And Instant Messenger

I open up Instant Messenger and start typing...

Me:  Um, have you ever seen a pks or pkb file?

Sr. DBA R: Yes.

Me:  Um, do you... run them?

(pause of Instant Messenger silence)

Sr. DBA R.: Yes.
(kim comment - he messenges like this. Very brief. To the point. He probably knows I'm trying to compose a message that sounds somewhat knowledgeable and this entertains him.)

Me: Um... how?

Sr. DBA R.: Open them in editor in Toad and then run them.

This is where I am busily scrounging in my mind to figure out how to do this, I mean, yes, technically, I understand what he means, but I am still sort of new to the little green frog.  I've been using this tool called Embarcadero and it seems easier, but none of the cool DBAs use, and I want to be cool.  Desperately, I want to be cool.  I want to use the Toad.

Me:  So... how do I do that in Toad? (oh, please come over please please please)

(Two moments of Instant Messenger silence)

Sr. DBA R shows up at my cubicle.  He was probably thinking oh my god, she's in Production maybe it's worth the 1 minute I spend with her in her cube to head off the 3 hours of RMAN recovery in case she wipes out the database.  Or maybe not.  I project a lot of my insecurities.

He very kindly shows me how to open editor, open my files and VOILA! There it is!  He cautions me to run pkS, then pkB.  And I run it! And it's against the wrong schema.  Whereupon he kindly shows me select name from v$database, which I have now consigned to making sure I always run before I do anything else ever in my life, ever.

And then I run them again.  They run great!  And ask, "Do I do commit?" and he wanders off saying, "Nope, it's ddl".  (which I KNEW didn't require commit!! Dammit!! But I forgot.)

And now I know what to do with pkS and pkB files.






10 comments:

  1. Hello Man

    Thanks it helps a lot !

    ReplyDelete
  2. Hello Woman,

    very funny!

    Thanks,
    Frank

    ReplyDelete
  3. I do agree with all the ideas you have offered in your post.

    They're really convincing and can certainly work. Nonetheless, the posts are too brief for starters. Could you please extend them a little from subsequent time? Thanks for the post.
    Check out my weblog - hcg is safe and effective for men

    ReplyDelete
  4. Why people still use to read news papers when in this technological globe the whole
    thing is existing on web?
    Also see my web page - Deborah Koval

    ReplyDelete
  5. Malaysia & Singapore & brunei greatest on-line blogshop for wholesale & quantity korean accessories,
    accessories, earstuds, necklace, rings, bracelet, hair & trinket add-ons.
    Deal 35 % wholesale rebate. Ship Worldwide
    Look into my web blog ... Korean accessories online shop

    ReplyDelete
  6. Malaysia & Singapore & brunei ultimate internet blogshop for wholesale &
    quantity korean accessories, earrings, earstuds, choker, rings, bracelet, hair & bracelet add-ons.

    Promotion 35 % wholesale rebate. Ship Worldwide
    Review my web site jogos de inteligȇncia

    ReplyDelete
  7. With havin so much content and articles do you ever run into any problems
    of plagorism or copyright infringement? My blog has a lot of unique content I've either authored myself or outsourced but it seems a lot of it is popping it up all over the internet without my authorization. Do you know any methods to help reduce content from being stolen? I'd
    genuinely appreciate it.

    my page web design jakarta

    ReplyDelete
  8. Greetings! Very useful advice in this particular post!
    It's the little changes that produce the most significant changes. Thanks for sharing!

    My blog post :: vegetarian cooking

    ReplyDelete
  9. What's up every one, here every one is sharing these kinds of know-how, therefore it's fastidious to read this weblog, and I
    used to pay a visit this blog daily.

    Also visit my web-site ... Arabic Books

    ReplyDelete
  10. THAAAAAAAAAAANKS from 2014...in the future we still don have a clue of how run the pks and the pkb...thanks to you an to the Google.

    ReplyDelete