AWS RDS Oracle Database – Download files from S3 bucket
Download Files from AWS S3 Bucket to RDS Oracle DB 1. Download all files from S3 Bucket folder Step 1: Login in to the...
February 12, 2023
Datapump Import with sqlerrm = ORA-20000: Unable to set values for index: does not exist or insufficient privileges
ORA-20000: Unable to set values for index<Index_Name>: Issue : We are migrating a Oracle Legacy On-prom DB from version 12c to AWS RDS Oracle...
February 3, 2023
How to connect the Azure SQL DB Managed Instance using Azure AD User Account.
Steps to connect Azure SQL DB Managed Instance using Azure AD User account. Step 1: Log into the Windows Jump Server using Remote Desktop...
February 2, 2023
Issues and Resolutions – AWS RDS Oracle DB
Issues and Resolutions Issues List Issue 1: Oracle Client Installation Issues UDI-00018: Data Pump client is incompatible with database version 11.2.0.4.0 Solution: Need to...
January 31, 2023
Oracle DB Import DataDump (impdp) Parameters and Import Types
Different ways of Oracle DB Import DataDump * IMPORT Full Schema DUMP – Single File Dump Impdp username/[email protected] dumpfile=Single_dump_file.dmp SCHEMAS=schema_name directory=DATA_PUMP_DIR logfile=log_file_name.log * IMPORT...
January 31, 2023
Oracle DB Export DataDump (expdp) Parameters and Export Types
Different ways of Oracle DB Export DataDump * EXPORT – FULL DUMP (Full = Y) – Single Dump File expdp username/[email protected] dumpfile=dump_file_name.dmp FULL=Y directory=DATA_PUMP_DIR...
January 31, 2023
AWS S3 bucket – Copy / Move files across folders
AWS S3 bucket – Copy / Move files across folders To copy and move files between Amazon S3 Buckets, you can follow the below...
January 31, 2023
SQL DB Backup Restoration in Azure SQL Managed Instance
SQL DB Backup Restoration in Azure SQL Managed Instance
January 25, 2023
Moving files from Local System folder to RDS Oracle Database using DBLink
Moving files from Local System folder to RDS Oracle Database using DBLink
January 25, 2023
Oracle Data Pump Does not Support Import
Oracle Data Dump Does not support Import with TSTZ version mismatch – Higher version to Lower Version Error Message: Ora-39002: Invalid operationOra-39002: Oracle Data...
January 25, 2023