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 On Mon, Jun 14, 2010 at 8:32 AM, Roberto Fernandez < [email protected]> wrote: > > > Sori cm curiosity, > > Ko di drop sih, kenapa ga main2 di staus nya ajaa supaya ga aktif etc. > > salam. > > Roberto Fernandez > Del Polytechnic of Informatics > > > ----- Original Message ----- > From: "Faridh Wisanggeni" > <[email protected]<faridh_wisanggeni%40yahoo.com> > > > To: "forum oracle" <[email protected]<indo-oracle%40yahoogroups.com> > > > Sent: Friday, June 11, 2010 9:57:32 AM GMT +07:00 Bangkok, Hanoi, Jakarta > Subject: [indo-oracle] QUERY DROP ALL > > Dear All, > > Ada gak sich, query untuk DROP all table,view,package,function dll didalam > satu user, shingga di usr itu kosong semua...?? > > Thank's before, > > Faridh Wisanggeni > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------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/
