Articles

INTRODUCTION TO SQL(Article -1)

INTRODUCTION TO SQL Overview : SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. What is SQL? SQL is Structured/Syntax/Sequential Query Language, which is a language for storing, manipulating and retrieving data stored in relational database. SQL… Read More

RECOVERY MANAGER BASIC COMMANDS.

RECOVERY MANAGER(RMAN)  COMMANDS. In this article , we will see all the best practices of RMAN commands. Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN provides a common interface, via command line… Read More

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

More Latest News »