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.
Hi,
Logged on as the m aster user on a Oracle 19 RDS database, I would like to execute the following:
GRANT EXECUTE ON XDB.DBMS_XMLSCHEMA TO appl_owner;
This fails with ORA-01031: insufficient...
3
answers
0
votes
685
views
asked a year agolg...
RDS permission issuelg...
![Error-Screenshot](/media/postImages/original/IMYG-GgkG_QJuXhwpsrK-hgw)
Hello AWS,
I have a Client requirement to create a USER and Grant ALL PRIVILEGES to this newly created USER. These SQL Queries...
1
answers
0
votes
292
views
asked a year agolg...
So, have some DMP files that was exported from a oracle on premise, using expdp.
And now from the linux EC2 instance i need import those dumps that is already there if is possible using the impdp but...
3
answers
0
votes
498
views
asked a year agolg...
I need to execute sys.validate_apex in order to make SPATIAL works on Oracle APEX. I tried the following code:
```
begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name =>...
1
answers
0
votes
532
views
asked a year agolg...
Hello,
I try to create an oracle database instance but I have this error with cloudformation and I can't find a solution.
Can anyone help with this problem.
Resource handler returned message:...
1
answers
0
votes
653
views
asked a year agolg...
I have already enabled RDS minor version upgrade and scheduled Friday at 10 pm. Even though there is a minor engine version upgrade available that I noticed 2 days ago, an auto-upgrade did not happen....
1
answers
0
votes
551
views
asked a year agolg...
Hello Community,
I am currently learning for the aws database specialty exam/certificate.
In my online courses and in the aws documentation for the rds option groups it specifies that you cannot...
2
answers
0
votes
301
views
asked a year agolg...
Hi,
We are using Glue to read data from on-premise Oracle DB table. The table is large and has 40+ columns. We are interested in data from only 3 columns. Does AWS Glue support reading from Oracle...
1
answers
0
votes
647
views
asked a year agolg...
Ia Amazon going to provide some way to upgrade in the future as the easy way of doing it involves operations using SYS which we don't have an access to?
Feedback would be appreciated on what clients...
2
answers
0
votes
555
views
asked a year agolg...
To Connect to AWSRDS Oracle I usually type sqlplus on the EC2 instance and I get a prompt user-name and I enter all the connection string and can connected
Example
[oracle@ip-xx-xx-xx-xx eeop]$...
2
answers
0
votes
481
views
asked a year agolg...
Hi,
I have a some AWS Lambda functions which connect to a Postgres SQL database hosted on EC2 and and Oracle DB hosted out of AWS. I have been facing some intermittent connectivity challenges in...
3
answers
1
votes
11826
views
asked a year agolg...
I am trying to execute a SQL script from AWS RDS Oracle instance.
The steps I followed
1) CREATE D A Directory and GRANTED READ WRITE
EXEC rdsadmin.rdsadmin_util.create_directory(p_directory_name...
3
answers
0
votes
1897
views
asked a year agolg...