Return
-
Title
TCP-E test failed against the database. It ran out of space in TOOLS tablespace. It's using too much memory or space. -
Description
TCP-E test failed against the database. It ran out of space in TOOLS tablespace. It's using too much memory or space.
Getting errors such as:
ORA-01653: unable to extend table EMR_DBA.E_TRADE_BAK by 16 in tablespace TOOLSFailed to create table E_BROKER from backup.Unable to execute statement in ExecuteSQL(). ORA-01658: unable to create INITIAL extent for segment in tablespace TOOLS -
Resolution
The "Refresh data using backup sets" option was used. This option will double the required data size on the database. So 25 GB size is required at least from original 12 GB, and note that the size is just an estimated size. Ensure there is available freespace after completing loading data because the database will grow during the run of TPC-E transaction Mix.