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

I'm not working this Amazon RDS stuff now, but for a while I was exploring a userid/role called RDSADMIN. There are a number of packages/stored procedures owned by/available to RDSADMIN. I believe the RDS documentation will describe them relatively well.

Good luck!

Gus

On Fri, Jul 27, 2018 at 8:23 AM angelo <angelolistas_at_gmail.com> wrote:

> 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