Blink SQL

Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…

Hannie
February 7, 2018
0 Comments

1. yum install postgresql-server postgresql-contrib 2. su postgresql 3. postgresql-setup initdb 4. vi /var/lib/pgsql/data/pg_hba.conf 5. Find the lines that look like this near the end of the file and change…

Hannie
February 5, 2018
0 Comments

Monitoring in Postgresql

In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…

Hannie
January 31, 2018
0 Comments

Restore Oracle DB in Linux

To restore a database from the default directory /backup/rman use the cmd cmd: RESTORE DATABASE; Restore Specific Tablespace: Instead of restoring the full database, you can also restore only specific tablespace…

Hannie
January 31, 2018
0 Comments

Backup Oracle DB using RMAN in linux

1. View Current RMAN Configuration Before we take the backup, we have to configure certain RMAN parameters. For example, how long you want to reatain the RMAN backup, etc. To…

Hannie
January 31, 2018
0 Comments

Oracle DBA Roles

A database administrator’s responsibilities can include the following tasks: Installing and upgrading the Oracle Database server and application tools Allocating system storage and planning future storage requirements for the database…

Hannie
January 30, 2018
0 Comments

Orcale DataBase Set up in Windows

Go to orcale.com Go to downloads as shown in the image and select the compataible version of the system by accepting the license and click on it to download. Provide…

Hannie
December 12, 2017
0 Comments

MongoDB

Features: ->MongoDB is a No SQL database. It is an open-source, cross-platform, document-oriented database written in C++.C-> It stores data as documents, so it is known as document oriented database. -> documents…

Hannie
December 10, 2017
0 Comments

SQLite

-> SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. -> SQLite does not have a separate server process. It…

Hannie
December 10, 2017
0 Comments

Basic Commands in Mysql

-> This is the world’s second most popular and widely used open source database. -> All the database names, table names and table fields name are case sensitive. -> To switch…