terima aksih sebelumnya... ini step dijalaninnya di server manager(svrmgrl) khan???... nah padahal user ga familiar dengan screen itu ... atau bisa gak step ini dijalankan melalui *.bat (dibuat script) atau harus lewat sql plus???
--- [EMAIL PROTECTED] wrote: > > Step-stepnya sbb: > 1. connect sys as sysdba > 2. drop user <nama_user> cascade; > 3. create user <nama_user> identified by <password> > default tablespace <nama_tablespace> > temporary tablespace <nama_temp_tablespace>; > 4.grant connect,resource to <nama_user>; > 5. Import deh... > > > > > > > wkus77 > > > <[EMAIL PROTECTED] To: > [email protected] > > > cc: > > > Sent by: > Subject: [indo-oracle] export import > > [EMAIL PROTECTED] > > > groups.com > > > > > > > > > 18/05/2005 08:58 > > > AM > > > Please respond to > > > indo-oracle > > > > > > > > > > > > > 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 > > > > > > > > > > > > __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail -- -----------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/
