Oracle DBA – A lifelong learning experience

Modifying a datafile within Amazon AWS

Posted by John Hallas on October 5, 2018

Amazon restrict access to the SYS user within AWS instances for safety and security reasons  – the safety aspect being that users cannot be trusted to not cause self-harm!

Wishing to increase or add a datafile to a tablespace is not allowed directly and you have to use the API “rdsadmin.rdsadmin_util” to manage this and other functions.

These functions are listed in here  and a further page provides some good examples

One little workaround which I found useful and have used in the past on ‘on-premise’ databases is to use the ‘alter tablespace TS1 resize 50G;’ format which is quite useful if it is a bigfile tablespace and therefore only has one datafile. In that way you do not have to specify a file name or use the ‘ALTER DATAFILE’ format which is restricted by AWS.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: