ORA-07445: exception encountered: core dump [tbsafl()+3791] - ORA-01013: user requested cancel of current operation (Doc ID 1486314.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 and later
Linux x86-64

Symptoms

Customer gets ORA-01013: user requested cancel of current operation in alert.log,

and ORA-7445 [tbsafl] in trace file when adding a datafile.

Changes

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

November 2011.

 

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';

CREATION_TIME
----------------
2012/06/14 19:04
2012/06/14 19:04
2012/06/14 19:04

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms