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 188.8.131.52 and later
Information in this document applies to any platform.
Is below action supported for Agile Database?
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.
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