Skip to content

Temp tablespace (AWS RDS)

OBI v4.1.8

  • By default creates Temp Tablespaces while creating VDB from RDS backup.

OBI v4.1.7 and below

When ingesting from an RDS database, the OBI plugin does not create temp tablespaces. Please add appropriate code in the configureClone hook to create Temp tablespaces for VDB. A sample snippet of code is provided below. Please customize it as per your requirement. 

export ORACLE_SID=<NAME OF VDB>
export ORACLE_HOME=<ORACLE_HOIME of VDB>
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

sqlplus / as sysdba <<EOF
alter trigger rdsadmin.rds_ddl_trigger2 disable;
alter trigger rdsadmin.rds_ddl_trigger disable;

alter tablespace temp add
tempfile
'<DELPHIX_MOUNT_PATH>/<DB_NAME>/rdsdbdata/db/RDSSOURCE_A/datafile/temp01.dbf' size 2000M;

alter tablespace sci_temp add
tempfile
'<DELPHIX_MOUNT_PATH>/<DB_NAME>/rdsdbdata/db/RDSSOURCE_A/datafile/sci_temp01.dbf' size 2000M;
EOF

Note: Update datafile name, path, and size for tempfiles in above snippet of code.