Re: Access/dump datafile (no alter system/database, e.g. AWS RDS)

 Hello Spinka,

you should use datapump there to make your import or export schema

here is how to:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

but... no sysdba access, I think dba, maybe

On 27 July 2018 at 07:53, vit.spinka <vit.spinka_at_vitspinka.cz> wrote:

> 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-l