SOURCE SAVE Save the Source Code and Table and Index Structures using PL/SQL After having gone through some papers on this subject, the need for a robust system has to be developed plugging all the holes, is felt and the result is this. The basic idea and the first paper that has been seen is …
PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs, making them more efficient, readable, and concise You need dynamic SQL in the following situations: …
ONLINE MOVE PARTITION EXAMPLES SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE; Table altered SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE INDEXES; Table altered SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE GLOBAL INDEXES; Table altered Source: Oracle
MY FIRST PROGRAM PLSQL Tutorials – MY FIRST PROGRAM IN PL/SQL DBMS_OUTPUT This supplied package is an essential tool to debug the program written. So, use this and write your first program. This package prints the output of the program on to the screen. You will read about many important supplied packages as you go …
PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs, making them more efficient, readable, and concise You need dynamic SQL in the following situations: …
ERROR AND EXCEPTION HANDLING PLSQL handles the errors caused at the server level and publishes them using the following functions: EXCEPTION Thisdatatype is declared in DECLARE section of the PLSQL code enables to call those as and when they are required. An internal exception is raised implicitly whenever your PL/SQL program violates an Oracle rule …
To achieve the highest levels of availability, resulting in zero or near-zero downtime for both unplanned outages and planned maintenance activities, customers frequently use the combination of Oracle Real Application Clusters (Oracle RAC), Oracle Active Data Guard, and Oracle GoldenGate. Traditionally, Oracle GoldenGate is installed and run locally on the database server that the GoldenGate …
Oracle Maximum Availability Architecture (MAA) GoldenGate Hub Read More »
The strategic integration of Oracle Exadata Database Machine and Oracle Maximum Availability Architecture (MAA) best practices (Exadata MAA) provides the best and most comprehensive Oracle Database availability solution. Oracle GoldenGate is a key component of MAA, providing a logical replication solution for fast platform migration and a near zero downtime solution for application and database …
This Oracle GoldeGate Maximum Availability Architecture (MAA) migration solution provides step-bystep instructions to set up and migrate any 11g Release 2 and later Oracle database, from any system platform (e.g. AIX, HP UX, Linux), from a single tenant to a multitenant architecture, or from a database not using Transparent Data Encryption (TDE) to a TDE …
Oracle Database Migration with an Oracle GoldenGate Hub Configuration Read More »
Oracle Database includes the following logical flashback features: Oracle Flashback Query You can specify a target time and run queries against a database, viewing results as they would appear at the target time. To recover from an unwanted change like an update to a table, you could choose a target time before the error and …
Copyright © 2002-2023 Srinivas Maddali, All rights reserved.