My Oracle Support Banner

Question on Online DB Maintenance using Online Redefinition To Agile Database (Doc ID 2421634.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

Is below action supported for Agile Database? 

We are opt to use the auto mode, means when we are using online redefinition method, structure will be changed.
Structure will be changed here I am referring to (e.g: we have NOT NULL column stated, after using online redefinition, it will convert to constraint instead)
Will this will bring any impact to our application?

Auto mode -
• For non-partitioned table: Online Redefinition (WARNING, structure will be changed)
• For partitioned table: Move Partition Online
• For non-partitioned index: Index Rebuild Online

FYI – Structure will be changed meaning if you have a “NOT NULL” contribute, it will convert to constraint after online redefinition.
The object ID will be changed as well. 

For normal defragmentation, we will be using "alter table move", "shrink" or "DBMS_REDEFINITION.REDEF_TABLE" command.
To accomodate online operation, we are trying to schedule a job to perform "DBMS_REDEFINITION.REDEF_TABLE".
We will detect any fragmented table/index and perform the defragmentation using "DBMS_REDEFINITION.REDEF_TABLE".
However, using this command will change the structure.

 

Solution

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
Goal
Solution


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