I have created a separate tablespace for audit and tried to change, but there is error.
CREATE tablespace audtbs datafile '/data/PMS/audtbs01.dbf' size 1G autoextend on;
BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(audit_trail_type=>DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, audit_trail_location_value => 'AUDTBS');
END;
Error report -
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1496
ORA-06512: at line 2
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.