- Newest
- Most votes
- Most comments
I tested your scenario with RDS Oracle 19c SE2 with the database option group with Spatial enabled. I ran the following query after a a snapshot restore with the same option group with Spatial enabled. Snapshot restore worked without issues. I had to pick the correct option group with Spatial enabled this was not the default. select count(*), owner, status from dba_objects where owner = 'MDSYS' group by owner, status;
count(*) owner status
4429 MDSYS VALID
select count(*), owner, status from dba_objects where status <> 'VALID' group by owner, status;
No rows returned
I tested the snapshot restore without picking the option group with Spatial enabled. I still had no invalid objects and MDSYS schema was missing. See the following queries:
select count(*), owner, status from dba_objects where owner = 'MDSYS' group by owner, status;
No rows returned
select count(*), owner, status from dba_objects where status <> 'VALID' group by owner, status;
No rows returned
Both of these tests is what I would expect from snapshot restore. I was not able to reproduce your scenario where snapshot restore did not work.
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
