How to Enable / Disable Restricted Session in Oracle Database
In restricted session mode only the users with restricted session …
How to Enable / Disable Restricted Session in Oracle Database Read More »
Databases
Articles dedicated to SQL and non-Sql databases/
ORA-00020 maximum number of processes exceeded
ORA-00020 maximum number of processes exceededCause: All process state objects are …
15 Oracle Exp Command Examples to Export Database Objects
Even if you are a sysadmin or developer, when you …
15 Oracle Exp Command Examples to Export Database Objects Read More »
How to lock / unlock oracle database user account
To unlock a user Run the following sql as administrator …
How to lock / unlock oracle database user account Read More »
MySQL error «Field xxx doesn’t have a default value»
If you get mysql error: «Field xxx doesn’t have a …
MySQL error «Field xxx doesn’t have a default value» Read More »
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′
After incomplete recovery of my one of the database, I …
ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′ Read More »