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
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
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
There is no excerpt because this is a protected post.
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
|
1 2 3 4 |
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 database
|
1 2 3 4 5 6 7 |
SYS>>shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SYS>>exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options |
Step 3 : Change… Read More
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
|
1 2 3 4 |
SYS>>select name from v$database; NAME ---------------------------------------- PRIMARY |
My Old Database name is PRIMARY Step 2 : Create a trace control file… Read More
Controlfile Multiplexing and De-Multiplexing In Oracle12c In this article we will learn what controlfile contains,How to perform controlfile Multiplexing and De-Multiplexing . Control file : Controlfile is a Physical file. Controlfile is a small binary file which contains the current physical structure of database. Control… Read More
