ORA-07445: exception encountered: core dump [tbsafl()+3791] - ORA-01013: user requested cancel of current operation
(Doc ID 1486314.1)
Last updated on FEBRUARY 11, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Customer gets ORA-01013: user requested cancel of current operation in alert.log,
and ORA-7445 [tbsafl] in trace file when adding a datafile.
This issue may happen with creation of a compressed tablespace, or addition of a datafile to a compressed tablespace, after installation of 112031DBPSU and 11203BP2 which came out in
You need to check the date the tablespace was created:
SQL> select a.CREATION_TIME from v$datafile a,v$tablespace b where a.ts#=b.ts# and b.name ='TSNAME';
If it was created after installation of those patches, it could be that the tablespace was initially created without compression, and compressed after its creation.
In this case,adding a datafile will still fail.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document