Export.BAT File:
@echo off
C:\oracle\ora92\bin\EXP.EXE parfile=export.par
Export.PAR File:
userid=user_id/user_password@host_name
OWNER=user_id
GRANTS=Y
ROWS=Y
INDEXES=Y
CONSTRAINTS=Y
FILE=export.dmp
LOG=export.log
This only exports the objects for the specific user_id
>Dear All,
>
>I wanted some information about how to automate the task of taking the backup of Oracle database thru Export utility by the means of an Batch file (.BAT file)...So that once the batch file is created , I can schedule the task at the specified time interval thru Scheduler.
>
>As you all know that the backup of the Oracle database thru Export utility (EXP.BAT) is an command line interface program which accepts command line parameters... Is it possible to include them in a Batch file ???
>
>Eagerly awaiting ur reply....
>
>Thanks & Regards
>
>Sachin S. Kothare
Mark McCasland
Midlothian, TX USA