Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Online patching considerations for External Table

edited Aug 20, 2021 10:11AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi,

At present we are doing upgrade from 11.5.10 to R12.2.4 and  DB version is 11g, In the CEMLI process we found few packages are using external tables to load data to staging tables.

As part of online compliance do we have any considerations for external tables as explained below?

We are deleting and creating the external tables in the package using dynamic SQL, in case of normal tables we can use ad_zd_table.DROP_TABLE, ad_zd_table.upgrade what about the external tables?

Thanks,

Kumar K

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS LCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center