DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: export dump

  1. #1
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    export dump

    Is there any way to input the system date while the export writes the dump to it like I:\export\prod_08192005.dmp?

    Its very tedious to daily rename the files(more than 20) and looking to automate, since i store 2 weeks of export dumps in the same storage drive.

    Gurus......................
    "What is past is PROLOGUE"

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you got to write a script for that and just put the current date to a script variable and dynamically generate the parfile

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by dbasan
    Is there any way to input the system date while the export writes the dump to it like I:\export\prod_08192005.dmp?

    Its very tedious to daily rename the files(more than 20) and looking to automate, since i store 2 weeks of export dumps in the same storage drive.
    Why do I even try?
    Jeff Hunter

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Pando, is there any custom built script where i can work on it fast?

    thanks for your time..........
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by marist89
    Why do I even try?

    when you are asked to do.........?
    When no choice...........!!
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by dbasan
    Pando, is there any custom built script where i can work on it fast?

    thanks for your time..........
    Since your server appears to be Windows,
    try using WinBatch to create the parfile and execute the export.

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by marist89
    Why do I even try?
    Because you care!

  8. #8
    Join Date
    May 2001
    Location
    London
    Posts
    149
    I think u r looking for this kinda script.......

    @ECHO OFF
    FOR /F "TOKENS=2-5 DELIMS=/ " %%F IN ('DATE /T') DO (
    SET MM=%%F
    SET DD=%%G
    SET YYYY=%%H
    )
    SET CURDATE=%MM%%DD%%YYYY%
    d:\oracle\ora817\bin\exp user/pwd@service file=d:\backup\dumps\exp_data_%CURDATE%.dmp log=d:\backup\dumps\exp_data_%CURDATE%.log
    pause

  9. #9
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by pareshg
    I think u r looking for this kinda script.......

    @ECHO OFF
    FOR /F "TOKENS=2-5 DELIMS=/ " %%F IN ('DATE /T') DO (
    SET MM=%%F
    SET DD=%%G
    SET YYYY=%%H
    )
    SET CURDATE=%MM%%DD%%YYYY%
    d:\oracle\ora817\bin\exp user/pwd@service file=d:\backup\dumps\exp_data_%CURDATE%.dmp log=d:\backup\dumps\exp_data_%CURDATE%.log
    pause

    Pareshg, I hope this is what i am looking for and to make myself clear:

    can i create the batch file with the above script to get the required file name with sysdate.
    "What is past is PROLOGUE"

  10. #10
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Yes u can create the batch file with following code


    ============================================
    @ECHO OFF
    FOR /F "TOKENS=2-5 DELIMS=/ " %%F IN ('DATE /T') DO (
    SET MM=%%F
    SET DD=%%G
    SET YYYY=%%H
    )
    SET CURDATE=%MM%%DD%%YYYY%
    d:\oracle\ora817\bin\exp user/pwd@service file=d:\backup\dumps\exp_data_%CURDATE%.dmp log=d:\backup\dumps\exp_data_%CURDATE%.log
    exit

    ============================================

Posting Permissions

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


Click Here to Expand Forum to Full Width