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

Different Block Size of ORACLE

Different Block Size of ORACLE  Oracle 9i supports tablespaces with different block sizes. This allows large tables and indexes to have a larger block size than smaller objects. It also means that tablespaces can be transported between databases with differing block sizes. The database is… 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

Oracle:HEALTH CHECK REPORT(Capturing Archive information).

Oracle:HEALTH CHECK REPORT(Capturing Archive information). In this article we will implement to capture the Archive information using Shell script. Lets create a table which can store Archive  information. Connect to SYS user and execute below statement.

Create unique index and primary key  on  ARCHIVE_USAGE_HISTORY… Read More