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

MOSC Banner

FND_LOBS converting from basic to secure file questions (Re-Org as per note 1451379.1)

edited Aug 20, 2021 9:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

Hi all,

Hope someone can answer these questions:

Customer is performing FND_LOBS table Re-Org , since the table size is 3.8TB. Following Metalink Note 1451379.1, they are using Online Redefinition Method to re-org FND_LOBS but not moving the Files to Securefile.

Questions

1) They are creating interim FND_LOBS table in a new tablespace Called  APPS_TS_MEDIA1.

  Since they are creating new tablespace which is non OATM should they do any step to register the new tablespace with Application.

2) Is it mandatory to create the tablespace with "UNIFORM" allocation type?

  Their current APPS_TS_MEDIA tablespace is with "UNIFORM" and is having lot extents. Can they create the new tablespace with AUTO ALLOCATE type?

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center