Oracle 10G DBダンプ　Exportコマンド　バッチメモ


c:
cd C:\oracle\product\10.2.0\db_1\BIN
set NLS_LANG=Japanese_Japan.JA16SJIS
set Path=C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
set time2=%time: =0%
exp userid/password@SID GRANTS=Y OWNER=(schemaA,schemaB,schemaC) ROWS=Y COMPRESS=Y DIRECT=Y recordlength=65535 FILE=E:\slp_%time2:~0,2%.dmp

exit

cd C:\oracle\product\10.2.0\db_1\BIN

set NLS_LANG=Japanese_Japan.JA16SJIS

set Path=C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

set time2=%time: =0%

exp userid/password@SID GRANTS=Y OWNER=(schemaA,schemaB,schemaC) ROWS=Y COMPRESS=Y DIRECT=Y recordlength=65535 FILE=E:\slp_%time2:~0,2%.dmp

exit