maaf nich...
saya bingung cara buat bact filenya... tolong donk
jelaskan .... soalnya belum pernah buat sebelumnya
--- Ujang Jaenudin <[EMAIL PROTECTED]>
wrote:
> 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
> >>>
> >>>
> >>>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------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/
