batch file:
echo off
for /f "tokens=2-4 delims=/ " %%a in ('DATE/T') do ( set NewDay=%%a-%%c-%%b)
set DUMP_FILE=D:\DMP\DMP_%NewDay%
set PAR_FILE=D:\DMP\DMP.TXT
set LOG_FILE=D:\DMP\DMP_%NewDay%
echo userid=user/[EMAIL PROTECTED] > %PAR_FILE%
echo indexes=y >> %PAR_FILE%
echo grants=y >> %PAR_FILE%
echo statistics=none >> %PAR_FILE%
echo constraints=y >> %PAR_FILE%
echo recordlength=8192 >> %PAR_FILE%
echo compress=n >> %PAR_FILE%
echo buffer=32768800 >> %PAR_FILE%
echo log=%LOG_FILE%.log >> %PAR_FILE%
echo file=%DUMP_FILE%.dmp >> %PAR_FILE%
set PAR_FILE=D:\BPMS_DMP\DMP.TXT
exp parfile=%PAR_FILE%
del %PAR_FILE%
=============================================
Linux environment:
bikin bash script:
#!/bin/sh
rm -rf tgl
date +%d_%m_%Y > tgl
read var_tgl < tgl
var_file="BPMS_"$var_tgl
DUMP_FILE="/home/oracle/dmp/$var_file"
PAR_FILE="/home/oracle/dmp/par_file.txt"
LOG_FILE="/home/oracle/dmp/$var_file"
echo "userid=user/[EMAIL PROTECTED]" > $PAR_FILE
echo "indexes=y" >> $PAR_FILE
echo "grants=y" >> $PAR_FILE
echo "statistics=none" >> $PAR_FILE
echo "constraints=y" >> $PAR_FILE
echo "recordlength=8192" >> $PAR_FILE
echo "compress=n" >> $PAR_FILE
echo "buffer=32768800" >> $PAR_FILE
echo "log=$LOG_FILE.log" >> $PAR_FILE
echo "file=$DUMP_FILE.dmp" >> $PAR_FILE
PAR_FILE="/home/oracle/dmp/par_file.txt"
exp parfile=$PAR_FILE
rm -rf $PAR_FILE
J
Fina Jofianty wrote:
>hi..guys,
>mau tanya dong-masih berkaitan dengan export import di
>oracle,
>kalau misalkan saya mau export dgn menggunakan batch
>file
>tapi utk nama filenya itu ada unsur tanggalnya (e.g:
>23052005Backup1.dmp)
>bisa ngak yach menghasilkan file dgn format tsb??
>
>
>thanks & regards
>Fina
>--- Ujang Jaenudin <[EMAIL PROTECTED]>
>wrote:
>
>
>>buat batch file, isinya :
>>
>>@sqlplus -S user/[EMAIL PROTECTED]
>>@c:\drop_table.sql
>>imp fromuser= touser= file= table= .
>>
>>
>>@c:\drop_table.sql
>>drop table xxxxx
>>
>>
>>salam,
>>J
>>
>>wkus77 wrote:
>>
>>
>>
>>>halo rekan-rekan
>>>
>>>saya punya masalah. saya ingin mengcopy database 1
>>>
>>>
>>ke
>>
>>
>>>database 2 tiap hari. masalahnya kedua database tsb
>>>ada di 2 tempat yang berjauhan dan company ga mo
>>>invest cisco. jadi tiap hari ada orang yang copy
>>>database 1 ke database 2. nah kalo masalah import
>>>
>>>
>>khan
>>
>>
>>>biasa. tapi di database 2 khan data/tabelnya khan
>>>harus didrop dulu. gmn caranya buat script drop
>>>
>>>
>>table
>>
>>
>>>yang ada di database 2 trus import data dari
>>>
>>>
>>database
>>
>>
>>>1
>>>
>>>atao ada ide yang lebih baik????
>>>
>>>
>>>terima kasih sebelumnya...
>>>
>>>
>>>widhi
>>>
>>>
>>>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
