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(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
HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP. In this article, we will see how to export data from remote database and import in source database. Source Database : iP address : 192.168.0.51 Instance Name : primary Remote Database : iP address : 192.168.0.61… Read More
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER. In this article we will learn how to schedule RMAN backup jobs through DBMS_SCHEDULER. Before reading this article Please check previous article on DBMS_SCHEDULER. Oracle: Scheduler Jobs in Oracle Database Step 1 : Create the Script That Invokes RMAN Create… Read More
ORACLE ANALYTICAL FUNCTIONS – 1 In this article, we will see how Analytical functions works in Oracle. Analytical Function : Analytical function is used to compute the aggregate values and perform aggregate operations it returns more than value in each group In sql we have… Read More
How to kill Long Running Sessions using scripts. In this article , we will see how to write script to kill running query on Oracle database. Aim : To kill Long Running Query Step 1 : Create a table DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno number,hiredate date);… Read More
Oracle :Batch updates using PLSQL Blocks. In this article , we will learn how to update million records in a table using plsql blocks. Aim : To avoid Undo errors –> For every 200 transactions we are keeping commit to avoid snapshot too old error.… Read More
Oracle: Scheduler Jobs in Oracle Database-2 In this article we will learn how to create jobs with different options in dbms_scheduler. Before reading this article please check previous article. Oracle: Scheduler Jobs in Oracle Database Lets check options available in create_job procedure Use desc dbms_scheduler… Read More
Oracle: Scheduler jobs in Oracle Database. In this article we will learn how to create jobs and schedule the jobs. You create one or more jobs using the DBMS_SCHEDULER.CREATE_JOB. You must have the CREATE JOB privilege to create a job in your own schema, and the CREATE ANY JOB privilege to create a… Read More
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
