My Oracle Support Banner

Cannot Move Audit Trail Data To A Different Tablespace: ORA-46267: (Doc ID 2452211.1)

Last updated on FEBRUARY 25, 2020

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Created a tablespace AUDIT_TRAIL_TS and keep adding data files (to 96 GB).
- Audit file only 4.4 GB
SELECT round(SUM(BYTES)/1024/1024) FROM DBA_SEGMENTS WHERE SEGMENT_NAME='AUD$';

ROUND(SUM(BYTES)/1024/1024)
---------------------------
  4480
- try to move audit to AUDIT_TRAIL_TS and
begin
 dbms_audit_mgmt.set_audit_trail_location(
  audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std,
  audit_trail_location_value => 'AUDIT_TRAIL_TS');
end;
/

- Getting ORA-46267: Insufficient space in 'AUDIT_TRAIL_TS' tablespace, cannot complete operation
- alter tablespace AUDIT_TRAIL_TS to compress, still see the same error

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.