database

How to create a database in postgres

Creating a database in postgres is very easy and it takes just few seconds. create database command is used to create the database.In this tutorial we will show different option with create database c...

How to multiplex control file in standalone database

Multiplexing in control_file is one of the best practices of oracle database setup. It means keeping control files in different mount point or disk groups , so that in case one mount points is inacces...

How to change the oracle database name using nid utility

  Follow below steps for changing the oracle database name using nid utility. We will change the database name from P2PRMD2 to P1D2ST. 1. Mount the database SQL> STARTUP MOUNT ORACLE instance star...

ORA-31623: a job is not attached to this session via the specified handle

PROBLEM:             While taking export or import  , you may face below issue. oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS di...

How to create a database manually

An oracle database can be created either using Manually or using DBCA( GUI Method).  But few organizations recommend to use manual method for creating database. Here I have provided steps for creatin...