Database Security Products (MOSC)

MOSC Banner

Shuld we use remap tablespace?

edited Feb 19, 2025 4:24PM in Database Security Products (MOSC) 4 commentsAnswered ✓

We are trying to export the audit trails from one of our instances and import it to an other instance on a different RAC. We also want to import the audit_trail on a different tablespace.
In the origin audit trails are stored into system tablespace. We want to import audit trails into a custom tablespace what we previously configured to store the audit_trail.
We have done the export, but when we try to import using this command: impdp '"sys/pass@formacio as sysdba"' directory=IMPORT_AUDIT dumpfile=AUDIT_%u.dmp logfile=AUDIT-import.log full=y parallel=2 we see that system tablespace is growing, so we assume the import is saving the data inside system tablespace. Furthermore, our custom tablespace "AUDIT_TBS" is practically empty.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center