Drop saja usernya, gunakan syntax :
DROP USER <nama_user> CASCADE;

Jangan lupa backup dulu databasenya. Gunakan syntax EXP
-----Original Message-----
From: Faridh Wisanggeni <[email protected]>
Sender: [email protected]
Date: Fri, 11 Jun 2010 10:57:32 
To: forum oracle<[email protected]>
Reply-To: [email protected]
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]

Kirim email ke