DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data pump export

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    data pump export

    hi guys,

    question on datapump export flashback_time

    i can take an expdp for a particular time or till that time

    expdp db1/db1 directory=db1dp dumpfile=db1.dmp logfile=pdb1.log parallel=8 tables=dlp561 flashback_time=\"TO_TIMESTAMP\(\'24-06-2008 16:59:59\', \'DD-MM-YYYY HH24:MI:SS\'\)\"


    i have a cron job that kicks off every day 5pm to execute the export but
    but how do i tell that take export or flashback parameter take export till 5pm
    in other words how can move on from hard coding the date

    thanks for your help

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking Use date function

    Like this?
    Code:
    cdt="`date +%d-%m-%Y` 16:59:59"
    expdp db1/db1 directory=db1dp dumpfile=db1.dmp logfile=pdb1.log parallel=8 tables=dlp561 flashback_time=\"TO_TIMESTAMP\(\'${cdt}\', \'DD-MM-YYYY HH24:MI:SS\'\)\"
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    thank you
    in the above CDT shows for the same day 25-06-2008 16:59:59.how do i show for previous day like this 24-06-2008 16:59:59

    thanks again for your time

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking tek-tips

    Check out this function courtesy of www.tek-tips.com forums.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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