Questions About Partitioning Audit File With UPA For Current Year (Doc ID 2176647.1)

Last updated on AUGUST 28, 2016

Applies to:

Identity Manager - Version 11.1.2.0.14 and later
Information in this document applies to any platform.

Goal

Suppose one forgot to add partition to audit file with UPA for the current year (for example year 2016).
1. Can one add it now for the year current year?

2. Would this be the correct script to run >

Alter table UPA split partition UPA_LATEST at (TO_DATE('01/01/2017','DD/MM/YYYY')) into
(partition UPA_2016 tablespace UPA_2016,partition UPA_LATEST tablespace UPA_MAX)
update global indexes;
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms