ah kaya obat aja ada efek samping. efeknya ya usernya bisa ilang, drop itu tidak bisa undo, bikin dependent object di schema lain mungkin jadi invalid. selain itu DDL termasuk expensive di cost.
server ndak ada urusan sama DDL. yang punya urusan databasenya. server kan physical machinenya. SUN tipe abc, dll.... lagian tujuannya buat apa ya? kalo buat user maintenance, apa ngga lebih gampang pake EM? tinggal klak klik kluk aja :) [email protected] wrote: > > Hello Ratno, > Monday, June 14, 2010, 5:12:20 PM, you wrote: > > Klu sering melakukan drop dan create user (user yang sama) > apakah ada efek samping terhadap server ora nggak ya. > Ini sering sekali saya lakukan untuk mesin yang di pakai sekedar uji > coba script sebelum di upload ke server aslinya > tks > > > pertanyaanya soalnya mengosongkan semua object kecuali si user tersebut. > > klo ane, sama seperti solusi yang dikasi sebelumnya. > > drop user nama_usernya cascade; > > > abis itu, bikin baru > > create user nama_usernya identified by password, dst,dst; > > > regards, > > ratno > > -- > Best regards, > fansul > mailto:[email protected] <mailto:fansul%40yahoo.co.id> > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik > terhadap spam > http://id.mail.yahoo.com > > > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.829 / Virus Database: 271.1.1/2938 - Release Date: 06/14/10 > 14:35:00 > > ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
