In this tutorial, I will write MySQL Cheat sheet by command line. How to Reset Root Password in MySQL? How…
Database Administrator
How to find latest Oracle database patchset
In this tutorial, How to find the latest Oracle database patchset: Patch Set Release (PSR). Sometimes you check the latest…
How to check dump file size in oracle
In this tutorial, How to check dump file size in Oracle? Sometimes you have to export all the databases and…
Oracle 12c unable to access port 5500 solve problem
In this tutorial, How to solve the problem “Oracle 12c unable to access port 5500”. Oracle the essential for DevOps…
Drop user cascade oracle
In this tutorial, How to Drop user cascade oracle. You must have Oracle DROP USER system privilege. Drop user cascade…
Oracle import dmp file
In this tutorial, How to using Oracle import dmp file. Create new schema Oracle import dmp file for new schema…
Oracle create tablespace
In this tutorial, How do I use Oracle create tablespace? Create multiple datafile with a single create tablespace. Oracle Permanent…
Mastering Date Manipulation in Oracle Database: Oracle change sysdate Tips and Tricks
In this tutorial How to change sysdate for Oracle Database server. Oracle gets the system day from OS server data.…
Export and Import in oracle
In this tutorial, I will export and import in Oracle 11g. Create DBA Directory Export all SCHEMA using expdp Import…
Oracle create schema
A schema is defined as a user that owns data such as tables, indexes and so forth. In this tutorial,…