Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    10

    Question Unanswered: Oracle DB User Backup Procedure

    Hi to ALL

    I want to Backup (create a DUMP) of Database User from Oracle Form e.g.
    When end user specify Name and Path of DUMP then after pressing Backup button from Oracle Form, it will create a dump at specified location
    e.g. D drive or E Drive. And Prompt for Successfully Completion of Procedure.

    I am using Oracle Form 6i and Database 10g R2 on Windows XP Professional.

    Thanks in Advance.

    Regards
    Thunder2777

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    launch SCHEDULER job which utilizes RMAN to complete DB backup
    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
    Sep 2010
    Posts
    10
    Hi

    Actually I want a procedure which I can write in a
    When Button Pressed Trigger. So that when user need to create a backup (DUMP) file, he simply open the form and press the button.

    Fortunately, I found the one which has SUCCESSFULLY done it.
    Code for that is as follow

    Trigger Name: When-Button-Pressed
    Item : Button

    PL/Sql Code for Oracle 8i Database

    host('exp80 userid=scott/tiger file=D:\Backup\scott-'||
    TO_CHAR(SYSDATE,'DDMMRR') ||'.dmp');

    PL/Sql Code for Oracle 9i - 10g Database

    host('exp userid=scott/tiger file=D:\Backup\scott-'||
    TO_CHAR(SYSDATE,'DDMMRR') ||'.dmp');


    Cheers

    Thunder2777

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >host('exp80 userid=scott/tiger file=D:\Backup\scott-'||
    >host('exp userid=scott/tiger file=D:\Backup\scott-'||

    How does form know/decide which command to include (exp80 or exp)?
    Does every user export only SCOTT schema?
    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.

Posting Permissions

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