I have set audit_trail=DB and created new tablespace for auditing (with datafile size 1G autoextend on) to separate audit tables from system tablespce.
I got error when i run following procedure to change tablespace.
The database is 11gR2.
BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(audit_trail_type=>DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,
audit_trail_location_value => 'AUDSYS');
END;
Error report -
ORA-46267: Insufficient space in 'AUDSYS' tablespace, cannot complete operation
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1659
ORA-06512: at line 2
46267. 00000 - "Insufficient space in '%s' tablespace, cannot complete operation"
*Cause: Could not complete the operation because the DBMS_AUDIT_MGMT API
involved movement of one or more audit tables and there was not
enough space in the destination tablespace.
*Action: Turn on tracing using DBMS_AUDIT_MGMT.SET_DEBUG_LEVEL to find
the amount of space required. Then, allocate that space in the
destination tablespace, even if destination tablespace datafile has
AUTOEXTEND option turned on. And then, retry the operation.