Oracle 11.2.0.1.0 on OL 5.7 64-bit
Either this is so obvious I'm looking right past it, or extremely obscure. My money is on the former.
SQL> @move_aud
SQL> set echo on verify on feedback on trimsp off
SQL> select
2 tablespace_name,
3 status,
4 extent_management
5 from dba_tablespaces
6 where tablespace_name='AUDIT'
7 ;
TABLESPACE_NAME STATUS EXTENT_MAN
------------------------------ --------- ----------
AUDIT ONLINE LOCAL
1 row selected.
SQL> --
SQL> begin
2 dbms_audit_mgmt.set_audit_trail_location(
3 audit_trail_type => dbms_audit_mgmt.audit_trail_db_std,
4 audit_trail_location_value => 'AUDIT');
5 end;
6 /
begin
*
ERROR at line 1:
ORA-02216: tablespace name expected
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1576
ORA-06512: at line 2