Have you ever seen this error message when you are trying to delete particular DB ? This error message tells us that DB in used and cannot be dropped. And sometimes I feel little bit annoying because I don’t have much time to ask anyone who access / remote DB to close their connection. So what […]
Database
Drop all tables without drop schema in Oracle
I just wanna post simple snippet script SQL in oracle. It used to drop all tables without drop schema. Open your SQL Editor (Im using SQLDeveloper). Run this script.
Oracle failed login SYSDBA insufficient privileges
When I trying to login as SysDBA in Oracle, I got this message : I asked my friend, and he has helped me to fix this problem (thank you very much to mas bogie XYBASE ), he said the problem is caused by “Root user can’t access the Oracle Environment Path”. Okay now I would […]
Reset Password SYSTEM in Oracle 11 g
Resetting password SYSTEM in Oracle is very easy, 1. Open your command line, and login as sysdba 2. Update new password by altering user 3. if your account has locked, you need to unlock first 4. The last try to login as system That’s all …
Spring 4 and Hibernate 4 Integration (using Oracle)
Oke weekend ini badan agak meriang, setelah kemarin kucing saya terkena pilek dan sepertinya nular ke saya jadi untuk weekend ini saya gunakan untuk exploring aja mudah – mudahan ada manfaatnya bagi nusa dan bangsa terlebih lagi untuk agama … (lebay dot com … xixixxi). oke guys tulisan ini adalah kelanjutan dari tulisan saya sebelumnya […]