Articles

RENAMING INSTANCE

RENAMING INSTANCE In this article we will learn how to rename a oracle instance. Step 1 : Check instance information SYS>>select instance_name from v$instance; Inst-Name ———- primary My instance name is primary. No i want to convert Primary to PROD. Step 2 : Shutdown the… 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 SYS>>select name from v$database; NAME —————————————- PRIMARY My Old Database name is PRIMARY  Step  2… 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 SYS>> desc… Read More

Storage Management in Oracle -2

Storage Management in Oracle -2 In this article we will learn about Storage Parameters . Before reading this article please go through with previous article. Storage Management in Oracle -1 Storage Hierarchy Summary In summary, the hierarchy of storage in Oracle is as follows: 1.… Read More

More Latest News »