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.
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario