Download Amazon Relational Database Service User Guide

Amazon Relational Database Service User Guide
Creating and Resizing Tablespaces and Data Files
Oracle Method
Amazon RDS Method
alter database [add|drop] sup- exec rdsadmin.rdsadmin_util.alter_supplementplemental log;
al_logging(p_action in varchar2, p_type in
varchar2 default NULL);
alter database add supplemental exec rdsadmin.rdsadmin_util.alter_supplementlog data (PRIMARY KEY) columns; al_logging('ADD','PRIMARY KEY');
alter database add supplemental exec rdsadmin.rdsadmin_util.alter_supplementlog data (ALL) columns;
al_logging('ADD','ALL');
alter database add supplemental exec rdsadmin.rdsadmin_util.alter_supplementlog data (UNIQUE) columns;
al_logging('ADD','UNIQUE');
Creating and Resizing Tablespaces and Data Files
Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files and control files. When
creating data files and log files you cannot specify physical file names.
The following example creates a tablespace:
create tablespace users2;
The following example creates temporary tablespace:
create temporary tablespace temp01;
Because the Oracle ALTER DATABASE system privilege is not available on Amazon RDS, you must use
ALTER TABLESPACE to resize a tablespace. The following example resizes a bigfile tablespace named
users2 to 200 MB:
alter tablespace users2 resize 200M;
For smallfile tablespaces, you need to add an additional datafile, like in the following example:
ALTER TABLESPACE users2 ADD DATAFILE SIZE 100000M AUTOEXTEND ON NEXT 250m MAXSIZE
UNLIMITED;
Setting Default Tablespace
Oracle Method
Amazon RDS Method
alter database default tablespace users2;
exec rdsadmin.rdsadmin_util.alter_default_tablespace('users2');
Setting Default Temporary Tablespace
Oracle Method
Amazon RDS Method
alter database default tempor- exec rdsadmin.rdsadmin_util.alter_deary tablespace temp2;
fault_temp_tablespace('temp2');
API Version 2014-10-31
249