Download sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip set db environment cd /home/oracle unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip cd sqlt/install sqlplus / as sysdba sql> start [...]
PYTHON: If you’re using Oracle Linux 7, you can use yum to install the CLI. sudo yum install python36-oci-cli The CLI will be installed to the Python site packages: [...]
Below the steps for enable DIAGNOSTICS option to a specific user in R.12. 1.Login as a sysadmin user in front end. 2.In the EBS dashboard , choose SYSTEM ADMINISTRATOR Responsibility under Main [...]
INTRODUCTION The below steps showes us how to migrate a 19c database using Transportable Tablespace. MIGRATION FROM LINUX TO WINDOWS MIGRATION FROM LINUX TO WINDOWS BY TRANSPORTABLE TABLESPACE [...]
INTRODUCTION: The below steps shows us how to enable the scp for file transfers in oracle cloud. Open the puttygen Import the target server ppk file [...]
The alter table move command moves rows down into un-used space and adjusts the HWM but does not adjust the segments extents, and the table size remains the same. The alter table move [...]
Opening Files from Server in Oracle Forms. Introduction: Script to open the Pdf or Image files from Server in Oracle Forms. Cause of the issue: In Oracle Forms user requested to open the Pdf or [...]
Dynamic Alert Message in Oracle Forms. Introduction: The Alert Message need to be changed at run time based on the condition criteria. Cause of the issue: In Oracle Forms, we have a standard [...]
API to Approve the POs. Introduction: API to Approve the POs. Cause of the issue: In PO Migration from one unit to another unit, the old unit POs need to be approved. To update the same we can [...]
Execute the below scripts for Backup Table Step1:- “CREATE TABLE scratch.RA_CUST_INT_INC0054156 as select * from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =****; / CREATE TABLE [...]