Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    41

    Unanswered: Create Procedure / Packages

    In Oracle 9.2 version

    I created a package with 1 procedure in it called ABC.

    I create ABC on date1 using USERIDA thru computerA
    I drop ABC and recreate ABC on date2 using USERIDA thru computerA
    I drop ABC and recreate ABC on date3 using USERIDB thru computerA
    I drop ABC and recreate ABC on date4 using USERIDC thru computerC

    How do I find out the different start / end date timestamps when the package ABC was created and dropped (history) and what userid was used from what computer (like OSUser, Machine, Terminal, etc)

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You could query USER_OBJECTS to retreive answer to the first part of your question (when it was created and time of the last DDL command). I really wouldn't know is it possible to find out OS user etc. Perhaps it is, but I'd bet opposite.

  3. #3
    Join Date
    Sep 2005
    Posts
    4
    You could write a DDL trigger to populate a table with the information you require. Some examples here

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If AUDIT was enabled, you'd have the desired information in the future.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2005
    Posts
    41

    Thanks - it works.

    thanks it works

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •