viernes, 14 de enero de 2011

MOVER AUD$ FGA_LOG$

select table_name,tablespace_name from dba_tables where TABLE_NAME='AUD$';





TABLE_NAME TABLESPACE_NAME





------------------------------ ------------------------------





AUD$ AUDITORIA









SQL> alter table sys.aud$ move tablespace AUDITORIA;









Table altered.









SQL> alter table sys.fga_log$ move tablespace AUDITORIA;





alter table sys.fga_log$ move tablespace AUDITORIA





*





ERROR at line 1:





ORA-00997: illegal use of LONG datatype













SQL> ALTER TABLE FGA_LOG$ MODIFY (PLHOL CLOB);









Table altered.









SQL> ALTER TABLE FGA_LOG$ MOVE TABLESPACE AUDITORIA;









Table altered.









SQL> select table_name,tablespace_name from dba_tables where TABLE_NAME='AUD$';









TABLE_NAME TABLESPACE_NAME





------------------------------ ------------------------------





AUD$ AUDITORIA









SQL>









DBMS_AUDIT_MGMT PL/SQL Package









Table 14-1 DBMS_AUDIT_MGMT Constants - Types of Audit Trails









Constant Data Type Value Description





AUDIT_TRAIL_ALL





PLS_INTEGER





15





All audit trail types. This includes the standard database audit trail (SYS.AUD$ and SYS.FGA_LOG$ tables), operating system (OS) audit trail, and XML audit trail.









AUDIT_TRAIL_AUD_STD





PLS_INTEGER





1





Standard database audit records in the SYS.AUD$ table









AUDIT_TRAIL_DB_STD





PLS_INTEGER





3





Both standard audit (SYS.AUD$) and FGA audit (SYS.FGA_LOG$) records









AUDIT_TRAIL_FGA_STD





PLS_INTEGER





2





Standard database fine-grained auditing (FGA) records in the SYS.FGA_LOG$ table









AUDIT_TRAIL_FILES





PLS_INTEGER





12





Both operating system (OS) and XML audit trails









AUDIT_TRAIL_OS





PLS_INTEGER





4





Operating system audit trail. This refers to the audit records stored in operating system files.









AUDIT_TRAIL_XML





PLS_INTEGER





8





XML audit trail. This refers to the audit records stored in XML files.