Questions tagged with Oracle
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
RDS Failover Testinglg...
Hi
I need to plan, design and test failover for some RDS oracle production servers running in multi-az environment.
Is there any documents or videos that discuss details for doing that?
Would you...
2
answers
0
votes
700
views
asked 2 months agolg...
We are trying to Replicate data from RDS in one account RDS in other account by Masking PII data. As part of this we are following below approach
Step 1: Replicate data from Source RDS to S3 by...
1
answers
0
votes
572
views
asked 2 months agolg...
We want to backup and restore Oracle RDS twice a day (incrementally) cross account at the schema and tables level, excluding DMS, Golden Gate, snapshots, and RMAN. What third-party solution is...
2
answers
0
votes
592
views
We are trying to Replicate Data from Oracle RDS to Target oracle RDS by Masking PII data For that we are following below approach:
1. Replicating data from Oracle RDS to 53 bucket by masking PII data...
1
answers
0
votes
564
views
asked 3 months agolg...
Hi
I am trying to create some alerts for RDS events so I can receive an email via SNS when a failure or backups occur.
I created a topic and then when I try to create an event subscription I get this...
2
answers
0
votes
616
views
asked 3 months agolg...
We are trying to do Data transfer by masking PII data from source RDS account to s3 bucket. But we are not able to add new column using add-column, we don't see any specific errors as well. we are...
1
answers
0
votes
746
views
asked 3 months agolg...
Hi all! I need some guidance on the proper way to connect to an Oracle Free Tier Autonomous Database from a Glue ETL Job. I’ve been using the following code snippet, but I encountered an error -...
0
answers
0
votes
614
views
asked 3 months agolg...
Hello,
Attempting to lock expired users in AWS Oracle RDS using a created procedure faces an "insufficient privileges" error. The procedure, designed to execute ALTER USER commands, encounters...
1
answers
0
votes
669
views
asked 3 months agolg...
I am importing the data dump file that I have downloaded from S3.
```
-----load schema
DECLARE
v_hdnl NUMBER;
BEGIN
v_hdnl := DBMS_DATAPUMP.OPEN(operation => 'IMPORT', job_mode => 'SCHEMA',...
1
answers
0
votes
947
views
asked 3 months agolg...
Is it possible having a read replica of an Oracle RDS instance in a different account and different VPC using VPC Endpoints?
2
answers
0
votes
752
views
Data replicationlg...
Which is the cheapest AWS service for data replication between two AWS accounts?
I am using Oracle DB for this experiment.
3
answers
0
votes
595
views
asked 4 months agolg...
Hi
I migrated an oracle 19c DB from on-premise to RDS using data pump exp/imp.
I noticed one application schema failed to be granted a permission "grant any role".
I used the RDS master account for...
2
answers
0
votes
562
views
asked 4 months agolg...