Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule schema backup thru Task Scheduler

User_PZTZEJul 21 2016 — edited Jul 25 2016

Hi All,

I created batch file to create database schema backup as follows:

expdp system/password@db_name SCHEMAS=graind18 DUMPFILE=expdpD18.dmp LOGFILE=expdpD18.log

I scheduled it to be executed each day thru Task Scheduler.

However, backup file is not created.

When I execute batch file, backup file get created in default DATA_PUMP_DIR directory, or in another directory If I create it and add it to be specified in the above "expdp" command.

I am wondering what I am missing here when scheduling backup thru Task Scheduler.

I have another Batch file which move database backup file to another location and it gets executed as scheduled.

I would appreciate any feedback.

Thank you,

Olivera

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2016

Added on Jul 21 2016

#database-key-features, #export-import-sql-loader-external-tables

5 comments

1,863 views