Oracle DBA
alireza, May 02, 2024 - 9:46 pm UTC
Hi,
regarding to your solution i have a related question:
I EXP the AUD$ from other test db and want to import it into AUD$ (with ONLA_DATA param).
Because the target test db has an empty AUD$ and i need data in it to make the test. and we are dealing with PDB
However i get an error by IMPDB:
$ impdp dba_admin/password@aidinfrdb89:1521/PDBTEST parfile=IMP_table_archive_audit.par
Import: Release 19.0.0.0.0 - Production on Thu May 2 13:52:43 2024
Version 19.17.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39166: Object SYS.AUD$ was not found or could not be exported or imported.
This is my IMPDP parfile:
DIRECTORY=DIR_DUMP
dumpfile=expdp_audit_test.dmp
LOGFILE=expdp_audit_test.log
JOB_NAME=impdp_audit
CLUSTER=N
remap_tablespace=AUDIT_AUD_TEST:SYSTEM
content=data_only
TABLES=('SYS.AUD$')
Any advice on this? Is it actually allowed to use IMPDP for the AUD$ (in the target db) ?
Thanks!
Alireza
May 07, 2024 - 3:37 am UTC
I would copy AUD$ to a "standard" table in a normal schema then export/import that, and then do an insert-select on the target