pak cipta, itu updatenya mau secara realtime, pak? klo emank mau secara realtime, kyaknya mending pake standby database dech, pak.. klo tetep mo pake export import, coba liat pake "exp help=y", kyaknya saya pernah liat ada pilihan inctype (increment type) tp saya sendiri bln pnah pake... mungkin bisa dicoba2 syntaxnya, pak...
moga2 mbantu.. regards, [L] --- cipta <[EMAIL PROTECTED]> wrote: > > terima kasih atas masukannya, tapi saya masih agak > bingung dengan > beberapa pilihan imp/eks tsb :D > misalnya : saya punya 2 buah server, 1 buat > operasional dan 1 buat > back up, nah jika saya ingin mengupdate perubahan > baik data, maupun > role dari server 1 ke 2 , yg digunakan schema, > tablespace, atw 1 db?? > > thx > ^_^ > > --- In [email protected], Leonard Sukendro > <[EMAIL PROTECTED]> > wrote: > > > > > > to pak cipta, > > > > import n export itu ada bbrp pilihan, pak, co: > > 1. export/import per schema, > > 2. export/import per tablespace, > > 3. export/import 1 database, dll > > > > biasa saya pake yg per schema, caranya > > dr os prompt ketik 'exp (nama user > oracle)/(password > > user oracle) file=(destination+nama file hasil > export) > > log=(destination + nama file log)' yg pilihan > "log" > > itu jg optional, gk usah di pake klo gk perlu log. > > co: exp scott/tiger file=/exim/scott.dmp > > log=/exim/log_scott.log > > > > utk importnya, dr os prompt ketik 'imp (nama user > > oracle)/(password user oracle) file=(destination + > > nama file yg akan di import) > > co: imp scott/tiger file=/exim/scott.dmp > > > > utk lbh jelasnya, dr os prompt ketik 'exp/imp > help=y' > > dsitu ada lbh byk option2 yg bisa dpake, pak.. > > > > moga2 bisa mbantu, pak :) > > CMIIW, > > [L] > > > > > > --- cipta <[EMAIL PROTECTED]> wrote: > > > > > > > > salam kenal, > > > saya mau import database, saya mau minta bantuan > nih > > > sama miliser yang > > > dah pengalaman, gimn cara import dan eksport db > di > > > oracle, apa pake > > > script khusus atw gmn?? > > > > > > thx > > > ^_^ > > > > > > > > > > > > > > > > > ____________________________________________________________________________________ > > Get the Yahoo! toolbar and be alerted to new email > wherever you're > surfing. > > > http://new.toolbar.yahoo.com/toolbar/features/mail/index.php > > > > > ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097
