Oracle Cloud Applications Now Live in Gen 2 Cloud Region in Mumbai
Oracle announces that it’s Gen 2 Cloud Region is now live in Mumbai. As a result of this deployment in India, the existing, as well as new customers, can now…
Read MoreAWS Lambda
Description: AWS Lambda is a serverless compute service that runs your code in response to events and automatically manages the underlying compute resources for you. You can use AWS Lambda to extend…
Read MoreOracle Multitenant in Database 12c Enterprise Edition
Description: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a standardized database version that…
Read MoreGenerate DDL source code using Oracle SQL
Introduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source. Database…
Read MoreOracle Always Free cloud services
Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database configuration…
Read MoreRMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error
This Post describes about RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If…
Read MoreScript to determine the high water mark of tables
TO CHECK THE HIGH WATER MARK LEVEL OF TABLES set verify off col table_name for a20; column owner format a10 column alcblks heading ‘Allocated|Blocks’ just c column usdblks heading ‘Used|Blocks’…
Read MoreORA-01741: illegal zero-length identifier
Posted by : Saravanan Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…
Read MoreInstalling various Database Components
Posted by : Mahe This Post describes about Installing various Database Components col COMP_ID for a20 col VERSION for a15 col STATUS for a10 col COMP_NAME for a40 select COMP_ID,…
Read MoreOracle Cloud Infrastructure New Feature – Block Volume user-defined backup policies
Oracle introduced new feature/functionality to Oracle cloud infrastructure Block Volume services scheduled backups feature – User defined Backup policies. Using this feature we can create our own/custom backup policies for…
Read More