RE: Access/dump datafile (no alter system/database, e.g. AWS RDS)
Date: Fri, 27 Jul 2018 13:36:30 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED0130E55DE7_at_EXNJMB25.nam.nsroot.net>
We have a similar cloud here. My question is how do I restore a table in dev? Or refresh a testing database from Prod? It’s not the best answer in the world.
Liz
Elizabeth Reen
CPB Database Group Manager
Service Now Group: CPB-ORACLE-DB-SUPPORT
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of vit.spinka
Sent: Friday, July 27, 2018 6:54 AM
To: Oracle-l
Subject: Access/dump datafile (no alter system/database, e.g. AWS RDS)
Hi all,
I wonder if there is a way how to get to the datafiles in say Amazon RDS, as there is no filesystem access. And the users cannot have alter system or alter database grants, so I can't even dump contents of a data block. The backups are file system snapshots, but these don't seem to be accessible, either.
Or am I missing somethings, is there a way how to access an arbitrary datafile block?
Thanks for all ideas!
Vit
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 27 2018 - 15:36:30 CEST