hai temen2 minta bantuan neh...
basis data kantor saya dulu pake oracle 8i..kemudian file back up nya misal :
data.dmp
dengan file data.dmp saya bisa import ke komputer lain (digunakan untuk mobile,
offline) yang menggunakan oracle 9i, dengan prosedur lewat ms dos dan perintah
IMP dst...
namun setelah komputer server kantor di ganti dengan oracle 9i, yang
menghasilkan file DMP dengan format tanggal (misal 12022005backup.dmp), saya
kesulitan dalam impor ke komputer lain, padahal prosedurnya sama dengan dulu,
hanya nama file saya sesuaikan dengan nama file dmp nya. atau prosedur impor
dmp dengan format tanggal berbeda?
mohon bantuan temen2 berhubung saya masih belum paham betul mengenai basis data
oracle,. agar saya bisa import file dump tersebut yang berformat tanggal ke
kompi saya, klo bisa yang pake ms dos (dengan script langsung) maupun dengan
bacth file.
thanks 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
>>>
>>>
>>>
--
-----------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 the Yahoo! Terms of Service.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
--
-----------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/
