EBS Customizations (MOSC)

MOSC Banner

I´m planning to put some tables in a separate tablespace/filesystem. Is there a restriction ?

edited Jun 16, 2011 12:40PM in EBS Customizations (MOSC) 7 commentsAnswered
Oracle EBS 11.5.10.2. Oracle Database 10.2.0.4 on AIX 5.3
I´m about to reorganize the Oracle Inventory (INV) tables after running a huge purge. The MTL_MATERIAL_TRANSACTIONS table is accessed a lot and I´d like to put it in a different tablespace than APPS_TS_TX_DATA (OATM). This SPECIAL tablespace will be created in a separate JFS2 filesystem. I´ll do the same with the table indexes, they will be in their own tablespace/filesystem.
Is there a restriction? Why shouldn´t I do that? Could I have problems applying patches?
 

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