RENAMING INSTANCE

RENAMING INSTANCE In this article we will learn how to rename a oracle instance. Step 1 : Check instance information

My instance name is primary. No i want to convert Primary to PROD. Step 2 : Shutdown the database

Step 3 : Change… Read More

Renaming the Oracle Database.

Renaming the Oracle Database. In this article we will learn how to rename a oracle database using trace controlfile . RENAMING DATABASE : Step 1 : Check the database name

My Old Database name is PRIMARY  Step  2 : Create a trace control file… Read More

Storage Management in Oracle -3

Storage Management in Oracle -3 In article we will learn creating tablespaces with storage parameters(DEMO). Before reading this article please check previous articles. Storage Management in Oracle -2 Demo On Storage Management : To view information about storage management use DBA_TABLESPACES or V$TABLESPACE

Note… Read More