Database Administration (MOSC)

MOSC Banner

Audit data copy from sys.dba_audit_trail - UTC time issue

I have a process that copy data from SYS.DBA_AUDIT_TRAIL to AUDIT_DP.AUDIT_PHX_USER_LOG table - every 15 minutes.

Issue: the SYS.DBA_AUDIT_TRAIL shows the timestamp value = 6:45:14 a.m. but when it insert rows in AUDIT_DP.AUDIT_PHX_USER_LOG shows 10:45:14 that is four hours later or the UTC time, why?

How can I fix this issue?

MERGE INTO AUDIT_DP.AUDIT_PHX_USER_LOG g

   USING SYS.DBA_AUDIT_TRAIL a

    ON (g.transactionid = a.transactionid)

WHEN NOT MATCHED

THEN

  INSERT   (g.os_username,

        g.username,

        g.userhost,

        g.timestamp,

        g.owner,

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