requesting information on Online patching standards

[satish]

Hi Erman,

Ordinary table ex:GL_JE_LINES

Oracle says 'Do not modify ordinary tables in the Run Edition while a Patch Edition exists'.Generally we will have some emergency datafixes to run immediately even while patching cycle exists.

I would like to understand what are the implications/problems if we do not follow this statement "Do not modify ordinary tables in the Run Edition while a Patch Edition exists"

Thank you

[ErmanArslansOracleBlog]

This is documented.. The statement about the Ordinary tables is clear.
But first you need to understand what an ordinary table is..

"Ordinary tables are created and maintained by Online Patching (and will have an editioning view)"

Oracle says ->

---
If the application logic modifies an ordinary table at runtime, it must use the AD_DDL interface to execute the dynamic DDL.

Do not modify ordinary tables in the Run Edition while a Patch Edition exists.."

---

So, this modification is about executing DDLs, not DMLs..

[satish]

Dear erman,

We are sorry if our understanding is wrong.please correct us

Our concern is,table is non-editioned,so any change to it will be visible to all editions.Then why do we need to execute AD_DDL  interface?

Thank you

[ErmanArslansOracleBlog]

Do you have an editioning view associated with that table or not?

[satish]

Hi erman,

We have an editioning view on the table.
We didnt understand why is this question asked but what is the difference if ev exists and if ev not exists?

[ErmanArslansOracleBlog]

Okay, basically you will not modify these kinds of tables during an online patching cycle.
What I mean by "modify" is , do not alter them! Do not issue DDL  !  We aren't talking about DML here.