oracle: how to create directory and grant permissions to users
Create & grant permission to directory in Oracle Create directory in …
oracle: how to create directory and grant permissions to users Read More »
Oracle
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 »
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 »
How to enable the Fast Recovery Area in Oracle 12c
If you haven’t already done so, enabling your system to …
How to enable the Fast Recovery Area in Oracle 12c Read More »
How To Delete Specific Archivelogs and Backups Using RMAN
As part of the regular backup file log maintenance, the …
How To Delete Specific Archivelogs and Backups Using RMAN 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 »
Useful sql scripts for Oracle DBA
Note: These scripts runs with SYSDBA privileges cpu_usage.sql – Show …
RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE
Ensuring that the system has been backed up and is …
RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE Read More »
How to put oracle database to archivelog
Shutdown the database. Exclusive start. Turn on archivelog. Check archive …