Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Exclamation Unanswered: Retrieving Source Code from Oracle 9i

    Hello everyone,

    I have a very bad problem. I was at my school's computer labs working on an Oracle 9i final project on Tuesday of this week. Apparently, there was some server maintenance going on that day. I had created three packages, two views, one trigger, and one stored procedure that was not included in a package. I logged off for the night, and came back the next morning only to find that my code I had saved in .sql files had vanished. Although I lost the code, I did create everything in oracle, so my question to you is can I retrieve the source code of my work from oracle?? Any help would be much appreciated!

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    by querying USER_SOURCE & USER_VIEWS correctly
    you'll be able to extract the source code.
    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.

  3. #3
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    SELECT NAME, text
    FROM USER_SOURCE;

    Thanks,
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by /2ump /2oast
    Hello everyone,

    I have a very bad problem. I was at my school's computer labs working on an Oracle 9i final project on Tuesday of this week. Apparently, there was some server maintenance going on that day. I had created three packages, two views, one trigger, and one stored procedure that was not included in a package. I logged off for the night, and came back the next morning only to find that my code I had saved in .sql files had vanished. Although I lost the code, I did create everything in oracle, so my question to you is can I retrieve the source code of my work from oracle?? Any help would be much appreciated!

    Thanks.

    In 9i that's so easy. Either you can use DBMS_METADATA or DataBee, DBArtisan, etc available tools.


    HTH,


    clio_usa - OCP 8/8i/9i DBA

  5. #5
    Join Date
    Apr 2004
    Posts
    8

    tool!

    This tool is very good too for viewing/compiling PL/SQL source.
    http://www.benthicsoftware.com

    This one is useful as well
    http://www.dkgas.com/oraedit.htm

Posting Permissions

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