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
677
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
289
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
496
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
528
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
650
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
549
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
300
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
642
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
549
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
477
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
11737
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
1880
views
asked a year agolg...