My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2022

Applies to:

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


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;


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.