In Oracle 11g, it is not possible to use Data Pump to export the AUD$ table directly:
[oracle@myhost ~]$ expdp directory=mrm dumpfile=aud.dmp tables=aud$
Export: Release 11.2.0.4.0 – Production on Sat Dec 8 17:30:47 2018
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYS”.”SYS_EXPORT_TABLE_01″: sys/******** AS SYSDBA directory=mrm dumpfile=aud.dmp tables=aud$
Estimate in progress using BLOCKS method…
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object SYS.AUD$ was not found.
ORA-31655: no data or metadata objects selected for job
Job “SYS”.”SYS_EXPORT_TABLE_01″ completed with 2 error(s) at Sat Dec 8 17:30:59 2018 elapsed 0 00:00:04
However, this can be done using the traditional exp/imp utilities:
[oracle@myhost ~]$ exp file=’/home/oracle/aud.dmp’ tables=aud$
Export: Release 11.2.0.4.0 – Production on Sat Dec 8 17:59:20 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
About to export specified tables via Conventional Path …
. . exporting table AUD$ 10 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
With the introduction of unified auditing in Oracle 12c, it is now possible to export audit-related tables using the INCLUDE=AUDIT_TRAILS parameter:
[oracle@myhost ~]$ expdp directory=mrm dumpfile=aud.dmp full=y INCLUDE=AUDIT_TRAILS
Export: Release 18.0.0.0.0 – Production on Sat Azar 17 18:15:39 1397
Version 18.3.0.0.0
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
Starting “SYS”.”SYS_EXPORT_FULL_01″: sys/******** AS SYSDBA directory=mrm dumpfile=aud.dmp full=y INCLUDE=AUDIT_TRAILS
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
. . exported “SYS”.”KU$_USER_MAPPING_VIEW” 6.218 KB 49 rows
. . exported “AUDSYS”.”AUD$UNIFIED”:”SYS_P754″ 145.0 KB 297 rows
. . exported “AUDSYS”.”AUD$UNIFIED”:”SYS_P181″ 64.41 KB 37 rows
. . exported “SYS”.”AUD$” 25.84 KB 12 rows
. . exported “SYS”.”DAM_CONFIG_PARAM$” 6.531 KB 14 rows
. . exported “AUDSYS”.”AUD$UNIFIED”:”AUD_UNIFIED_P0″ 0 KB 0 rows
. . exported “SYS”.”DAM_CLEANUP_EVENTS$” 0 KB 0 rows
. . exported “SYS”.”DAM_CLEANUP_JOBS$” 0 KB 0 rows
. . exported “SYS”.”AUDTAB$TBS$FOR_EXPORT” 5.953 KB 2 rows
. . exported “SYS”.”FGA_LOG$FOR_EXPORT” 0 KB 0 rows
Master table “SYS”.”SYS_EXPORT_FULL_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
/home/oracle/aud.dmp
Job “SYS”.”SYS_EXPORT_FULL_01″ successfully completed at Sat Dec 8 18:17:26 2018 elapsed 0 00:01:41
Top comments (0)