Epoch : The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but ‘epoch’ is often used as a synonym for […]
Database
Sticky Code : Kill Process Session Database in PostgreSQL
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 […]
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 …